COUNTA with IF trouble...
 

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 rows
corresponding to a specific data entry (K3). Then, from that narrowed
list of rows, I want to count the number of cells in column H that are
nonblank.


Any ideas?


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=479459

COUNTA with IF trouble...
 

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!

In article ,
TEAM wrote:

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 rows
corresponding to a specific data entry (K3). Then, from that narrowed
list of rows, I want to count the number of cells in column H that are
nonblank.


Any ideas?