MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding string


Posted by Jon Swanson on February 13, 2002 9:41 AM

I have a column that I need to total...the items times the per cost for a long column and I don't want to type the whole thing out..ie =SUM(D9*B9+D10*B10+D11*B11+D12*B12+D13*B13+D140*B140+D141*B141)

Does anyone know how to do this, Thanks, Jon Swanson


Posted by Juan Pablo G. on February 13, 2002 9:50 AM

Is this what you want ?

=SUMPRODUCT(B9:B141,D9:D141)

Juan Pablo G.

Posted by Aladin Akyurek on February 13, 2002 9:55 AM


=SUMPRODUCT((B9:B200),(D9:D100))

where B9:B200 houses number of items and D9:D100 cost per item.

Is this what you're looking for?

=====

Posted by Aladin Akyurek on February 13, 2002 9:57 AM

Didn't check if you were around. ;)

Posted by Mark W. on February 13, 2002 10:14 AM

BTW, as it was the SUM() function was superfluous [nt]