Sum only if cells are not blank in adjacent column

A

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.
 
T

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
 
A

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?
 
S

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top