How To Use Cells Without Values in a Formula
 

I want to summarize in a single cell at the bottom of the spreadsheet the
results of summing the summed product of multiplying two different columns.

This is the formula I want to write:
=(C12*$U12)+(C13*$U13)+(C14*$U14)+etc., etc.

However, column C cells may not have values in them. If there are no values
the error message #value! comes up. Is there a way to ignore cells without
values and still have all the cells with values sum themselves.

I have also tried this formula, same result:
=IF(D12=1,(D12*$U12)," ")+IF(D13=1,(D13*$U12)," ")

I am trying to avoid inserting a another column (s).

Thanks if your listening!
Roger H.

Try the SUMPRODUCT function, I believe it will do what you're asking.

Example:
=sumproduct(C12:C100,U12:U100)
Tha will multiply corresponding Cs and Us and add the products.

Regards,
Ron

Ron,
Bingo! Worked perfectly. I had studied that formula but the description did
not seem to fit. Thanks a milion! You just shortened my workday and I can go
home on time. Have a nice evening yourself.

Roger Hockett


"Ron Coderre" wrote:

Try the SUMPRODUCT function, I believe it will do what you're asking.

Example:
=sumproduct(C12:C100,U12:U100)
Tha will multiply corresponding Cs and Us and add the products.

Regards,
Ron