countif criteria from two cells are met

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

Hi,
i need to count items when the criterea is met in two cells. For
example, countif cell a = accounts and cell b = 2. I will be counting
these in a colum. Any ideas?
Thanks
Carl
 
Hi Carl
COUNTIF only accepts one condition so you have to use SUMPRODUCT:
=SUMPRODUCT(($A$1:$A$999="accounts")*($B$1:$B$999=2))

HTH
Frank
 
Back
Top