Max and Min formula

Giganews Newsgroups
Subject: Max and Min formula
Posted by:  wx4usa (wx4u…
Date: 2 Jan 2007

I have sales data on a worksheet. The data entries contain the day in
column A,  month in column B, the year in column C and corresponding
sales figures in column D.

THere can be many lines of data for January 2006, not just one per day.

What formula do I use to return the maximum(Max) sales figure for the
month if cell a1 contains the year (2006) and a2 contains the month
(January) ?

Thanks for your help in this!