Currently Being ModeratedFeb 4, 2013 5:35 PM (in response to David Journeay)
To add, I got it to work, but I can only add the full totals. I would like to break it down per day.
Here is what I got so far
(SUMIF Totals All, Payment, "Debit")
I. Have 2 tables, both with dates I would like to do something like
(SUMIF Totals All, Payment, "Debit") where Table 1 :: Date = Table 2 :: Date
Hope that helps. ;)
Thanks again for helping.
Currently Being ModeratedFeb 6, 2013 12:00 PM (in response to Wayne Contello)
Thanks for the help, I am using ios numbers on my ipad.
I am trying hard to find the syntax for my function I need. I know I need to use SUMIFS I just don't get how to do the conduction. I will try and tell you what I need and maybe someone has a link for me to follow or help. I have combed threw lots of blogs and some help but most are doing a date search or a true or false return or even when I find something that might help its returning a wild card. This is what I have, it would be easy if I could just post a photo of what I want to do.
So I have 4 sheets and 1 form. For this query I am only using 2 sheets. I cut hair (not so good and syntax) so after every client I have a form with name of client, DATE, SERVICE, PAYMENT, TOTALS ALL, and some other columns but not needed right now.
On my form I made a drop down for Sheet 1 :: PAYMENT, (none, Cash, Debit, Visa MasterCard, Other).
On sheet 2 :: Visa I did this, SUMIFS TOTALS ALL, PAYMENT, "Cash" so in numbers ipad I get lost a bit, I want this to return all payments of cash on the date.
On sheet 2 I have columns DATE, CASH, DEBIT, VISA, MASTERCARD, OTHER, ALL TOTALS these are columns.
So on sheet 2 I need to add more to my query, but I get syntax error when trying to get the date. Meaning I need to get my totals on each payment everyday. I have searched the Internet for this and no luck, yes there is help but most are doing a date search, I want it on the same date. I don't like bugging anyone but I also don't want to have to add up everyday how much I made on each of those fields. I know this can be done, I can do it in SQL, but numbers throws me.