CountIf Function

[Angela]

I am able to to perform a CountIf function with one
condition (i.e. If the cell equals January, count it).
But I would like the function to count when three
conditions are met (i.e. If cell one equals 'January' AND
cell two equals '2004' AND cell three equals 'Monday',
then count it). Is it possible to create this function?
Thank you!

 

[Frank Kabel]

Hi
use SUMPRODUCT for this. e.g.
=SUMPRODUCT(--(A1:A100="January"),--(B1:B100=2004),--(C1:C100="Monday")
)