Search within date range
I am making a budget based upon the workings of the "personal budget" template.
I am currently looking up Categories in my bank statement and SUM'in the numbers. This works fine!
Because i want to do this by month. i.e. all my food purchases for january 2015 instead of all food purchases in 2015,
i am currently manually selection the cells, but i am thinking that it must be possible for Numbers to check the date range
and only select the numbers based upon a monthly input from me?
My current setup is this:
My statement sheet looks like this, but has 5 years of data from 2010 - present.
Date |
Description |
CategoryName |
Amount |
08-11-2010 |
bla bla bla |
Food |
-1000,00 |
08-11-2010 |
bla bla bla |
Clothes |
-49,00 |
08-11-2010 |
bla bla bla |
Movies |
-389,90 |
08-11-2010 |
bla bla bla |
Food |
-399,00 |
My overview sheet looks like this:
Food |
Clothes |
Movies |
|
2015 |
|||
January |
1000 |
465346 |
43 |
February |
4546 |
346 |
436 |
March |
42 |
346 |
463 |
April |
24546 |
436 |
346 |
May |
2456 |
436 |
346 |
June |
This way i can keep track of all my spendings.
My current formula is based upon the "Personal budget" formula:
SUMIF(Category;A5;$Amount)
Mine looks like this:
SUMIF(Data::Table 1::$F$217:$F$298;B$3;Data::Table 1::$G$217:$G$298)
Because i am selecting each month manually.
It sums up the chosen category based upon the "A5" which is the category, and then looks up in the category name column and sums the found Amount numbers.
Nice and easy.
Is it not possible to get the formula to do the same but based upon a single month and year?
I could easily type in the month in the formula, that would not bother me, but i do not know what "Select this month" formula to use.....
Hopes this makes sense.
Macbook Pro, Mac OS X (10.4.10)