I'm trying to construct budgets for personal and businesses in numbers but I cannot seem to figure out how to to SUMIFS condition with Dates... like I want it to automatically read all the 2019/01/??'s in the date column to be able to filter them to a certain graph and chart.
Help! :(.
Thank you again for your time.
B
MacBook Pro 13", macOS 10.14
The method used in your formula (and as revised by Badunit requires a second column header containing the date of the start of the 'next month'. You can eliminate the ned for this 'extra' columns at the end of the period recorded by use of the EDATE function to calculate the end date for each period.
Using the same sample table as yours, here is a revised version of the formula as it is entered in B2:
=SUMIFS(AMOUNTS,CATEGORY, $A2, TRANSACTION DATE, ">="&B1, TRANSACTION DATE, "<"&EDATE(B1,1))
Regards,
Barry
The method used in your formula (and as revised by Badunit requires a second column header containing the date of the start of the 'next month'. You can eliminate the ned for this 'extra' columns at the end of the period recorded by use of the EDATE function to calculate the end date for each period.
Using the same sample table as yours, here is a revised version of the formula as it is entered in B2:
=SUMIFS(AMOUNTS,CATEGORY, $A2, TRANSACTION DATE, ">="&B1, TRANSACTION DATE, "<"&EDATE(B1,1))
Regards,
Barry
SUMIFS(sum-values, test-values, condition, test-values…, condition…)
=SUMIFS(AMOUNTS,CATEGORY, $A2, TRANSACTION DATE, ">="&B1, TRANSACTION DATE, "<"&C1)
Note it is "<"&C1, not "<="&C1, unless you want to include the first day of that month, too.
This is what I'm trying to do
That is the better solution because at some point the formula will be in the last column and there will be no next column with a date in the header.
Help! How can I do Sumifs wildcard with date ranges ?
