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]
