countif criteria from two cells are met

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
 
F

Frank Kabel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif(and 2
Using <= in countifs statement 1
countifs Function not giving desired result with date criteria 2
Count Number of Unique Cells That Don't Have Certain Characters 0
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Multiple arguments 3
Countif, multiple criteria 6
Excel function - countif 2

Top