Which function to use to count the records satisfying two criteria?

[preety]

Hi- This is really URGENT.
Problem: In MS Excel, column A has values ranging from 1 to 5. Column
has values ranging from 1 to 10. I need to count how many records hav
Column A value as "5" and Column B value as "1". Which function t
use?

Have tried "Countif", but this function works only for 1 criteria, i.e
I can count the number of records that have Column A value as "5" o
Column B value as "1". Is there any other function that can be used.

This is very urgent

 

[Max]

Try something like: =SUMPRODUCT((A1:A100=5)*(B1:B100=1))

Adjust range to suit
(but both ranges must be identical).

--
hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com
for email