Sum only if cells are not blank in adjacent column
 

Hi,
I have a simple scorecard that Ive built with available points in column B
and a score in column C. Sometimes not all the column C's are filled out due
to the process wasn't observe. I only want to sum up total points available
in column B if the adjacent cell in column C has a numeric value.

Sum only if cells are not blank in adjacent column
 

Maybe something like
=SUMPRODUCT(--(LEN(C1:C15)0),B1:B15)

Change the ranges in columns C & B to match your data. You can't include
whole columns when using SUMPRODUCT.

Hope this helps,

Hutch

"arch0072" wrote:

Hi,
I have a simple scorecard that Ive built with available points in column B
and a score in column C. Sometimes not all the column C's are filled out due
to the process wasn't observe. I only want to sum up total points available
in column B if the adjacent cell in column C has a numeric value.

Sum only if cells are not blank in adjacent column
 

=SUMPRODUCT(--ISNUMBER(C1:C100),B1:B100)


"arch0072" wrote:

Hi,
I have a simple scorecard that Ive built with available points in column B
and a score in column C. Sometimes not all the column C's are filled out due
to the process wasn't observe. I only want to sum up total points available
in column B if the adjacent cell in column C has a numeric value.

Sum only if cells are not blank in adjacent column
 

thanks that worked, i have a new issue now. i have other cells doing a sum
of the number in the defined cell below and they are coming up #DIV/O! now...
if there a way to make them appear blank if the sumproduct is 0?

"Teethless mama" wrote:

=SUMPRODUCT(--ISNUMBER(C1:C100),B1:B100)


"arch0072" wrote:

Hi,
I have a simple scorecard that Ive built with available points in column B
and a score in column C. Sometimes not all the column C's are filled out due
to the process wasn't observe. I only want to sum up total points available
in column B if the adjacent cell in column C has a numeric value.

Sum only if cells are not blank in adjacent column
 

On Sep 2, 1:18 pm, arch0072
wrote:
thanks that worked, i have a new issue now. i have other cells doing a sum
of the number in the defined cell below and they are coming up #DIV/O! now...
if there a way to make them appear blank if the sumproduct is 0?

Sounds like you have a division, not a sum. Here's a basic formula
format:

=IF(cell=0,"",SUM)