Splitting daily totals

300 Views 3 Replies Latest reply: Feb 6, 2013 12:00 PM by David Journeay
Calculating status...
Currently Being Moderated
Feb 4, 2013 4:20 PM

Been searching for a formula that will split my daily totals. I use SUMIF to get my daily totals matching the date. Like this

SUMIF Table 1 :: Date, Table 2 :: Date, SubTotals

In my form I made a drop down with a few different set string values i.e. (Visa, Cash, MasterCard, Other)

What I want to do is on another page do a SUMIF with a condition ="Cash" so I want to get the totals of all the cash sales I did that day. I know I need a date condition.

Would it be

SUMIF Table 1 :: SubTotals, Table 1 :: Date= Table 2 :: Date, =Table 1 :: Payment="Cash"

SUMIF Table 1 :: SubTotals, Table 1 :: Date= Table 2 :: Date, =Table 1 :: Payment="Visa"

SUMIF Table 1 :: SubTotals, Table 1 :: Date= Table 2 :: Date, =Table 1 :: Payment="MasterCard"

? I am good with numbers basic but when I need a where or equals to I get lost. These forms have helped in the past. I don't even care if have this info on the same sheet I just need help to get the different totals of each payment the client chooses that day.

After every sale I input my information and I made a table row with set string values as I stated at the top. PAYMENT Visa, Cash ...

D

• Level 6 (11,850 points)
Currently Being Moderated
Feb 4, 2013 6:01 PM (in response to David Journeay)

Try the sumifs() function.

Also you can get a detailed description of the function by selecting the menu item "View > Show Function Browser"

More Like This

• Retrieving data ...

Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.