Mac Numbers question, can I put two IF statements together?

Discussion in 'Mac Basics and Help' started by carmidy, May 21, 2013.

1. carmidy macrumors newbie

Joined:
Nov 21, 2010
Location:
In cold, cold South Dakota
#1
Okay so I have simplified the table shown quite a bit. Basically.... I need to know how many of each fruit Alice (and all the rest of the customers) has purchased without having to manually go in and find their name and add them together myself. I can get totals for total units of fruit purchased, and total units purchased for each customer. But I am having a heck of a time figuring out how to get a breakdown for each customer.

Does that make sense? I would just go in and pick them out manually, but for our business we have SO many transactions it would be a nightmare to have to go in and pick them all out, and then remember to add them as we add new transactions.

2. MacForScience macrumors 6502

Joined:
Sep 7, 2010
Location:
USA
#2
If I am understanding your question correctly, then you might try this:
=SUMIFS(<values to sum>,<first condition value range>,<condition 1>,<second condition value range>,<condition 2>).

Example
=SUMIFS(C2:C6,A2:A6,"=Alice",B2:B6,"=Kiwi")

You would create a report template, and fill in a name or what have you, and then have each item you want to enumerate the total for listed, with the value computed by the above function.

Not sure if that is what you are looking for.

Cheers