CountIf Function

  • Thread starter Thread starter Angela
  • Start date Start date
A

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!
 
Hi
use SUMPRODUCT for this. e.g.
=SUMPRODUCT(--(A1:A100="January"),--(B1:B100=2004),--(C1:C100="Monday")
)
 
Back
Top