How do I count nonblank cells that meet criteria in another ce
Thanks once again....that will do it.
"Domenic" wrote:
In article ,
jimswinder wrote:
Domenic:
Thanks that worked....
You're welcome!
what do I need to replace "x" with in the formula if I
want it to find ANY text (non blank cells)?
Try...
=SUM(IF(A2:A19=A1,IF(C2:C19<"",1,0)))
....confirmed with CONTROL+SHIFT+ENTER.
Hope this helps!
|