Thread: Product and Sum on 2 rows
View Single Post
 
Old 04-27-2011, 06:33 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
Welcome to the forum.

You can do this with SUMPRODUCT().

Code:
=SUMPRODUCT(A1:Z1,A2:Z2)
Reply With Quote