Sum only if cells are not blank in adjacent column

[arch0072]

Hi,
I have a simple scorecard that I’ve 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.

 

[Tom Hutchins]

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

 

[Teethless mama]

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

 

[arch0072]

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?

 

[Spiky]

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)