View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hostonthecoast hostonthecoast is offline
external usenet poster
 
Posts: 1
Default counting non blank cells for "sum(if" formula

I've been reading through previous threads and can't find the solution to my
problem. I need to count the number of cells that are "not blank" in column G
after columns C and D meet the criteria ie:

=SUM(IF('ALL WO List'!$C$1:$C$11716="FBR",1)*(IF('ALL WO
List'!$D$1:$D$11716="MECH",1)*(IF('ALL WO List'!$G$1:$G$11716="not
blank",1))))

Wild cards (?*) and "counta" don't seem to work....what am I missing?
--
thanks,
hostonthecoast