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

  • Thread starter Thread starter preety
  • Start date Start date
P

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
 
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
 
Back
Top