excel training courses - SUMIF - Two Variables

Hi Heather,

I don't know what the trainers would do, but I'd use 2 columns to sort this out, then hide them to keep my spreadsheet tidy

let's say for example your dates purchased are in column D and your colours are in column E.

In row 1 of column G type this:

=IF(AND(D1>=39142,D1<=39202),1,0)

this will return a 1 if the date in cell Dx is between March 1st and April 30th

then in row 1 of column H, type this:

=IF(AND(E1="blue",G1=1),1,0)

this will return a 1 if cell Gx = 1 and if cell Ex = blue

then you can sum up column H and you have the total number of "blue" bought in March & April