Count Number of Rows

B

Boying Opaw

In a given range, I only want to count the rows when certain columns satisfy
corresponding criterias. How do I do this?

Say I have Rows 1 to 10 and Columns A to D. I only want to count the rows
when the content of A = criteriaA and the content of B = criteriaB. What
formula do I use?
 
T

T. Valko

Use cells to hold your criteria.

F1 = criteriaA
G1 = criteriaB

Then:

=SUMPRODUCT(--(A1:A10=F1),--(B1:B10=G1))
 

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

How To Sum Rows 3
Count number of rows with specific text 2
COUNT rows on external sheet if between date range 3
COUNTIF multiple crietria 7
Counting Number of Discrepancies between 2 rows 2
Conditional count of rows dependent on multiple columns 1
Count rows based on multiple criteria 3
use month in cell date to sum all relevant cells 2

Top