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

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?

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.

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

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

sales upload.xlsx (498.6 KB, 8 views)

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:That puts TRUE on all the rows that you want included in your sum. Then your "if" column is 30, like this:If you're using A1 notation, the same thing look only slightly more complicated:How's that?

Thank you Bob

appreciate your help