Currently Being ModeratedMay 7, 2012 10:45 PM (in response to schmiford)
You're almost there.
SUMIF calculates a sum of values that meet a single condition.
SUMIFS calculates a sum of values that meet all of a set of conditions.
The syntax is slightly different. Here's the description, from the Function Browser in Numbers '09:
Note that the sum values (Income Breakdown::$Amount) is the first argument for SUMIFS, rather than the last, as it was for SUMIF. Test-value, Condition pairs are set in the same manner as in SUMIF.
Currently Being ModeratedMay 15, 2012 10:09 AM (in response to Barry)
I finally got a chance to mess with this and I'm still getting an error. It says "SUMIFS isn't a valid function name". If that's the case then that won't work for me, but I don't understand why it would be in the Function Browser then.
Hopefully the image is large enough. This is what I have going on. I tried the SUMIFS and put the Income Breakdown :: $Amount in the front. All the desired columns light up, I made sure the choices in the Purchase column match the choices in the Income 2012 A column. Is it possibly because the Purchase column is set up with pull down menus? Would that change things? Thank you for your help so far, it made sense, I'm just not getting it to work.
Currently Being ModeratedMay 15, 2012 4:47 PM (in response to schmiford)
Numbers '08? I don't have that version to check it out but maybe it doesn't have SUMIFS. Version '09 has it.
Currently Being ModeratedMay 15, 2012 6:01 PM (in response to Badunit)
You're right, SUMIFS didn't exist in Numbers '08.
You can get around this problem by adding a column that combines the two conditions, then SUMIF with the new column as a single condition.
For instance, if you want to sum all the values associated with a particular color and size, in columns C and D, in Column E fill with =C&D. This will give you values like RedSmall and BlueMedium. Do a SUMIF using column E as the condition range and look for RedSmall, or whatever.
Currently Being ModeratedMay 15, 2012 8:19 PM (in response to Badunit)
Yes, after more research I realized it is because I am using the 08 version of Numbers. Never saw a reason to upgrade. I'll have to work with reorganizing my columns in a way that I can use the SUMIF formula. Thank you for the help, I hope I remember all this when I finally upgrade.