[Solved] Sum the multiple of 2 columns w/o creating a 3rd

[stevenm]

Im trying to do something like =SUM(E2*C2:E18*C18)

I need to multiple several column entries by a count column on the same row and get a total for these but would like to do so without creating an extra totals column ( as there are 11 columns to total all multiplied by the count column.

Just wantyed to save creating columns and hiding them as sure theres a calc for it ?

[robleyd]

Maybe SUMPRODUCT() might do what you want? If not, perhaps provide a sample spreadsheet illustrating what data you have and the result you need.

[Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here.

[stevenm]

CWL2.pdf

(108.4 KiB) Downloaded 81 times

Thanks David

This is the columns im trying to work with i think sumproduct may have the answere

Attached is a screen dump in pdf , im wanting to multiply the column val;ues by the unique count of heach house type to get the total number of each type window and door in the job, so mytotal = B2*D2 + B3 * D3 + B4 * D4 + etc ...

CWL2.pdf

(108.4 KiB) Downloaded 81 times

[stevenm]

RESOLVED

=SUMPRODUCT($C2:$C21;E2:E21)