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