How To Use Cells Without Values in a Formula

R

Roger H.

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.
(e-mail address removed)
 
R

Ron Coderre

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
 
R

Roger H.

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
 

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