How do I COUNT from 2 different ranges

  • Thread starter Thread starter LIZZIE
  • Start date Start date
L

LIZZIE

I don't know how to create a formula for counting information from 2
different ranges.

I need to be able to count certain information from Column A if it
matches certain information in Column D.

Count (If information in column A =0_F and information in column D=II.

Thanks for any help.
 
Hi

Try using SUMPRODUCT:
=SUMPRODUCT((A2:A1000="criteria1")*(D2:D1000="criteria2"))

With SUMPRODUCT you cannot use full columns as ranges (eg A:A:) and all
ranges must be the same size.
Hope this helps.
 
Back
Top