Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2014, 10:25 AM
jcaal50 jcaal50 is offline excel formula Windows 8 excel formula Office 2010 64bit
Novice
excel formula
 
Join Date: May 2014
Posts: 4
jcaal50 is on a distinguished road
Default excel formula

I need a formula that can add the last cell of date Totals in my excel sheet. (6.63+13.49 etc).

Thank you for your help.

4-1-2014
inv. sales taxable non tax tax freight nontax exempt sales tax
25 375.00 375.00 0.00 0.00 0.00 0.00 000 5.63
4-1-2014 Totals 375.00 375.00 0.00 0.00 0.00 0.00 0.00 5.63

4-2-2014
25 222.00 222.00 0.00 0.00 0.00 0.00 0.00 3.33


26 176.00 0.00 0.00 0.00 85.00 0.00 176.00 0.00
30 677.00 677.00 0.00 0.00 0.00 0.00 0.00 10.16
4-2-20214 Totals 1075.00 899.00 0.00 0.00 85.00 0.00 176.00 13.49

Last edited by jcaal50; 05-13-2014 at 11:54 AM. Reason: it not clear
Reply With Quote
  #2  
Old 05-13-2014, 10:32 AM
BobBridges's Avatar
BobBridges BobBridges is offline excel formula Windows 7 64bit excel formula Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 685
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

This sounds as though you just want the SUM function. But that is so very simple that I cannot believe it's all there is; you wouldn't say you couldn't do that. I think we need more information. Can you post a sample worksheet, showing what data you have and describing the desired result?
Reply With Quote
  #3  
Old 05-13-2014, 12:34 PM
jcaal50 jcaal50 is offline excel formula Windows 8 excel formula Office 2010 64bit
Novice
excel formula
 
Join Date: May 2014
Posts: 4
jcaal50 is on a distinguished road
Default

Well, I do not want just Sum cell 5 and then cell 10 manually, because my spreadsheet is up to 47 pages.

so would like to create a formula.

Thank you.
Reply With Quote
  #4  
Old 05-14-2014, 02:47 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline excel formula Windows 7 64bit excel formula Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,484
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Please post a sample sheet ( no pics please) - Thx
Reply With Quote
  #5  
Old 05-15-2014, 12:37 PM
jcaal50 jcaal50 is offline excel formula Windows 8 excel formula Office 2010 64bit
Novice
excel formula
 
Join Date: May 2014
Posts: 4
jcaal50 is on a distinguished road
Default Formula

here is the spread sheet, I did highlighted what I would like to add just for you to see it.

I do sum the column after I clear other things from there, but I wanted to save time by just add them up with a formula .

thank you for your help.

attach the file.
Attached Files
File Type: xlsx sales upload.xlsx (498.6 KB, 2 views)
Reply With Quote
  #6  
Old 05-15-2014, 06:24 PM
BobBridges's Avatar
BobBridges BobBridges is offline excel formula Windows 7 64bit excel formula Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 685
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Got it: You want to add up the figures in column 26 (or column Z, if you're using that old-fashioned and vastly inferior A1 notation) but only from those rows that in column 1 have a text value ending in " Totals:". Do you want it all the way down, or just the first part that you highlighted? No matter; I would use SUMIF.

SUMIF wants to know three things: 1) The "if" column, that is, the one you're checking to see whether the number should be included in the total; 2) The condition, that is, what has to be in the "if" column to qualify; and the sum range, the column that holds the actual numbers to be added up. Column 1 (or A) is the first argument, and column 26 (or Z) is the third.

But what do you put in the second argument, for the condition? You can't just put "Totals:"; none of the values in column one are equal to "Totals:", they just end in "Totals:". And unless someone else here has a brighter idea than I do (Peco? Paul?), you can't put that straight into the SUMIF function.

So you'll need to create an extra "helping" column, probably at the right. Suppose in column 30 you put this formula:
Code:
=RIGHT(RC1,8)=" Totals:"
That puts TRUE on all the rows that you want included in your sum. Then your "if" column is 30, like this:
Code:
=SUMIF(C30,TRUE,C26)
If you're using A1 notation, the same thing look only slightly more complicated:
Code:
=RIGHT(A<row>,8)=" Totals:"
=SUMIF(AD:AD,TRUE,Z:Z)
How's that?
Reply With Quote
  #7  
Old 05-16-2014, 04:01 PM
jcaal50 jcaal50 is offline excel formula Windows 8 excel formula Office 2010 64bit
Novice
excel formula
 
Join Date: May 2014
Posts: 4
jcaal50 is on a distinguished road
Default

Thank you Bob

appreciate your help
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel formula Excel formula help please! dreamer1963 Excel 2 03-16-2014 03:59 AM
excel formula Excel Formula oRie Excel 2 02-28-2012 07:48 PM
excel formula ** Excel Formula djreyrey Excel 8 04-15-2011 03:55 PM
excel help Formula sellspeed Excel 15 03-10-2010 10:57 AM
Excel Formula Help masoom84 Excel 1 03-07-2009 09:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft