Excel Query - Count based on 2 columns 1

[Jock1970]

Hi Guys,
I'm sure this must have been asked on here before but my search didn't reveal any similar questions.

I need to count how many records have certain criteria in 2 columns e.g. how many records have the word "Church" in Column A AND the number "1" in Column E. I can't see how to double up the 'Countif' function to achieve this

I can get round the problem by creating an extra column which joins the data from Column A and Column E and then a single 'Countif' works but there must be another way.

Regards,

Jock

 

[KenWright]

=SUMPRODUCT((A1:A1000="Church")*(E1:E1000=1))

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------

 

[Jock1970]

Thanks Kenwright,

that's exactly what I wanted !

Cheers,

Jock