Total a column contingent upon the cell to the right being non-bla
 

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

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

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

.

Total a column contingent upon the cell to the right being non
 

Thanks for the catch, Jacob. Must have been a little groggy last night.

Fred

"Jacob Skaria" wrote in message
...
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

.