W
wx4usa
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!
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!