View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Total a column contingent upon the cell to the right being non

Fred meant to say

=SUMIF(D:D,"<",C:C)

--
Jacob


"Fred Smith" wrote:

=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


.