iworknumbers
I have some basic data
Name | Amount
Jake | 10
Jake | 12
Jake | 13
Ben | 1
Ben | 14
Ali | 9
Ali | 4
I want to total up the amount for each person so I end up with something like
Jake | 35
Ben | 15
Ali | 13
Rather than specifying which cells are Jake's, Ben's and Ali's I want to do this using a function. Pseudo code might look like:
TOTAL = WHERE `Name` IS "Jake" IN `COL-A` + `Amount`
Here's a better option:
COUNTIF formulas for each of your Pop-Up menu options ([=COUNTIF(Account Status,"Paid")], [=COUNTIF(Account Status,"30 Days")], etc.)Note that this will color ONLY the cells in the 'Account Status' column. There are some tricks to color the entire row, but this should be enough to catch your eye.
You can also use AppleScript if you need more complex summaries, but scripts cannot run automatically, where conditional rules do.
This functionality is embedded and its default behaviour. Of course if adding a row will be done using this option:
Best Answer
It would appear that
SUMIF()does exactly this