Mutliply rows in big amounts

[vb43]

I have a years worth of Scrap material that needs to calculated. In one
column i have qty of 3161 items and in another column I have the unit cost
per qty item. Can I mutliply in rows all at once?

 

[Jacob Skaria]

=SUMPRODUCT(A1:A3161,B1:B3161)

If this post helps click Yes

 

[Luke M]

So, you want something that would mathematically do: (A2*B2)+(A3*B3)+...etc?

=SUMPRODUCT(A2:A4000,B2:B4000)

 

[vb43]

Yes, that i could apply to all of it somehow? or i would by figuring out each
by calculator

 

[Luke M]

The formula that Jacob and I presented using SUMPRODUCT is what you are
looking for.