I'm trying to find a budget template for Numbers -- adapted from the checkbook template, maybe? --
where one can enter daily transactions (with category) in 12 different monthly tables, show each month's category sums in tables next to the daily ones,
and also have a table for Year-to-Date category sums, probably at the top of the whole thing.
In other words, each individual transaction would have to be added to its monthly category table, AND to the Year-to-Date category table.
Has anyone done this? Can it be done in Numbers?
That makes more sense than my original reading. The function you are looking for is "SUMIFS."
Here's an example, with the transactions recorded in the "Data" table, and the January sums reported in the "Summary" table.
"Data" contains no formulas.
A1 contains the start date, Jan 1, 2012.
The rest of column A contains the category names, which must exactly match the names used in the Data table.
B2 contains the formula, which is filled down the rest of column B:
Summary::B2: =SUMIFS(Data::$C,Data::$B,"="&A,Data::A,">="&$A$1,Data::$A,"<="&EOMONTH($A$1,0) )
For an amount to be included in the SUM, three conditions must be met:
-- The transaction category must match the category in that row of Summary.
-- The transaction date must be on or after the date in A1 of Summary
-- The transaction date must be on or before the last day of the month in A1 of Summary.