Thread: [Solved] Would appreciate help with formula or function
View Single Post
 
Old 03-12-2011, 08:53 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi eaglepi,

Suppose you want to find the quantity * price for the item in D2, where it's unit price is in E2. The formula in, say F2, would be:
=D2*E2
You can input that forumula then simply copy it down to row 626. To get the sum of all items in column F, you could use a formula like:
=SUM(F:F)
in any other column, or:
=SUM(F2:F626)
in, say, F1, F627, or any other cell not in the F2:F626 range.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote