#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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?
|
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
Please post a sample sheet ( no pics please) - Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
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. |
#6
|
||||
|
||||
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:" Code:
=SUMIF(C30,TRUE,C26) Code:
=RIGHT(A<row>,8)=" Totals:" =SUMIF(AD:AD,TRUE,Z:Z) |
#7
|
|||
|
|||
Thank you Bob
appreciate your help |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel formula help please! | dreamer1963 | Excel | 2 | 03-16-2014 03:59 AM |
Excel Formula | oRie | Excel | 2 | 02-28-2012 07:48 PM |
** 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 |