Thread: Total a column contingent upon the cell to the right being non-bla
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default Total a column contingent upon the cell to the right being non-bla
=sumif(C:C,"<",D:D)

Regards,
Fred

"Ed Livingston" wrote in message
...
I need a total from Column C for each cell which has an adjacent cell in
Column D that is non-blank.
--
Industrial Technology Teacher
Timberlake High School
Spirit Lake, ID

Reply With QuoteReply With Quote