Counting with more than one criteria

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

Hi, I'm new to this and I have probably a easy question. I'm trying to count
the following. If Column B has a P in it and Column H = 100% or more I would
like it to count. Sounds pretty easy but for the life of me I can't figure
it out.

Thanks
 
Hi Lori

One way
=SUMPRODUCT(($B$1:$B$1000="P")*($H$1:$H$1000>=100%))
Change ranges to suit, but note you can't use whole columns as ranges
(except for XL2007)
 
Try this:

=SUMPRODUCT(--(B2:B10="P"),--(H2:H10=>100))

Note: Your ranges must be specified (cannot be entire column). Adjust the
ranges as needed.

Does that help?
Paul
 
Perfect, Thanks so much.

Roger Govier said:
Hi Lori

One way
=SUMPRODUCT(($B$1:$B$1000="P")*($H$1:$H$1000>=100%))
Change ranges to suit, but note you can't use whole columns as ranges
(except for XL2007)
Click to expand...
 
Thanks

PCLIVE said:
Try this:

=SUMPRODUCT(--(B2:B10="P"),--(H2:H10=>100))

Note: Your ranges must be specified (cannot be entire column). Adjust the
ranges as needed.

Does that help?
Paul
Click to expand...
 
Back
Top