Thread: can someone help me with this formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
  
Posts: 2,494
Default can someone help me with this formula
for columns b and c, if b is blank and c 1, i want the count for column c.

i tried these to no avail

=COUNT(IF(B3:B33="",C3:C31,C3:C33))

=SUMPRODUCT(B3:B33="")*(C3:C331)
--


Gary



Reply With QuoteReply With Quote