Thread: Sum Product if? Three columns
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gmunro gmunro is offline
external usenet poster
  
Posts: 34
Default Sum Product if? Three columns

Biff wrote:
Hi!

Try this:

=SUMPRODUCT(--(B2:B5=""),A2:A5,C2:C5)

Biff

This worked perfectly. You guys are the wind beneath my wings.
Incidentally, what does the -- mean"

Glen

Reply With QuoteReply With Quote