Thread: Mutliply rows in big amounts
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Mutliply rows in big amounts
=SUMPRODUCT(A1:A3161,B1:B3161)

If this post helps click Yes
---------------
Jacob Skaria


"vb43" wrote:

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?
Reply With QuoteReply With Quote