Thread: SUMIF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
  
Posts: 293
Default SUMIF
Yes

=SUMIF(C1:C10,"",D1:D10)

OR
=SUMIF(C1:C10,0,D1:D10)

Stew

"nc" wrote:

Can I use a sumif function to sum where the criteria are blank cells? Or is
there an alternative function?
Reply With QuoteReply With Quote