ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel 2007 Help
Summing question Summing question
Register FAQ Forum Rules Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 11-14-2008, 10:24 AM
nikosgr nikosgr is offline
Registered User
  
Join Date: 14 Nov 2008
Location: Greece
Posts: 3
nikosgr is an unknown quantity at this point
Summing question
Hi all...

Can someone please enlighten me on how i can sum multiple formats without having to type them one by one ? What i want to do is find the profit based on the purchasing and selling price of a product and multiplying it by the number of products sold. The format i use is that one:

=(H2*(F2-E2))+(H3*(F3-E3))

The problem is that it goes up to cell No 44 so it will take me much time to complete such a simple task.

Thanks in advance
Reply With Quote
  #2  
Old 11-14-2008, 10:30 AM
shg's Avatar
shg shg is offline
Forum Moderator
  
Join Date: 21 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 7,423
shg is a glorious beacon of light shg is a glorious beacon of light shg is a glorious beacon of light
Welcome to the forum.

=SUMPRODUCT(H2:H44 * (E2:E44 - F2:F44))

Please take a few minutes to read the Forum Rules about thread titles before starting your next thread.
__________________
Entia non sunt multiplicanda sine necessitate.
Reply With Quote
  #3  
Old 11-14-2008, 10:44 AM
nikosgr nikosgr is offline
Registered User
  
Join Date: 14 Nov 2008
Location: Greece
Posts: 3
nikosgr is an unknown quantity at this point
Thanks for the fast reply. Although i get 0 as the sum, am i doing something wrong ?

Will read forum rules. Thanks again..
Reply With Quote
  #4  
Old 11-14-2008, 10:55 AM
shg's Avatar
shg shg is offline
Forum Moderator
  
Join Date: 21 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 7,423
shg is a glorious beacon of light shg is a glorious beacon of light shg is a glorious beacon of light
Quote:
Although i get 0 as the sum, am i doing something wrong ?
Dunno. Post a workbook?
__________________
Entia non sunt multiplicanda sine necessitate.
Reply With Quote
  #5  
Old 11-14-2008, 11:13 AM
nikosgr nikosgr is offline
Registered User
  
Join Date: 14 Nov 2008
Location: Greece
Posts: 3
nikosgr is an unknown quantity at this point
Quote:
Originally Posted by shg View Post
Dunno. Post a workbook?
Fixed... thanks
Reply With Quote
Reply

Bookmarks

New topics in Excel 2007 Help

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 12:02 AM.

ExcelTip.com - Archive - Top

Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0