Thread: Sum when one cell is blank & another cell is not blank.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Sum when one cell is blank & another cell is not blank.
=SUMPRODUCT((D1:D100)*(C1:C100="")*(F1:F100<""))

adjust to suit.
--
Gary''s Student - gsnu200843


"Greta" wrote:

I want to sum the values in column D when the value in column C is blank and
the the value in column F is not blank. (I'm using Excel 2003. )
Reply With QuoteReply With Quote