COUNTA with IF trouble...

T

TEAM

I am working with the following formula...

{=COUNTA(IF(C16:C500=K3,H16:H500))}


My goal is to look at that data in column C to locate all row
corresponding to a specific data entry (K3). Then, from that narrowe
list of rows, I want to count the number of cells in column H that ar
nonblank.


Any ideas
 
D

Domenic

Try...

=SUM(IF((C16:C500=K3)*(H16:H500<>""),1))

....confirmed with CONTROL+SHIFT+ENTER, or...

=SUMPRODUCT(--(C16:C500=K3),--(H16:H500<>""))

....confirmed with just ENTER.

Hope this helps!
 

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

Count NonBlank Rows with Criteria in another column 5
count nonblank cells with conditions 2
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
SUMIF with criteria "<>" & "=" 4
Need greater than = .. less than = combined with index/match state 6
Count number of rows with specific text 2
CountIF or COUNTA for specific text 6
count nonblank cells 3

Top