I've worked out a budget document, in which I put in all of our expenses and would like to sum the up for specific date ranges. However, not from the 1st to the 31st of the month, but from the 15th of one month to the 14th of the following month.
So I have two columns, one with the dates and then the adjacent with the individual expense.
Can anyone help me with this? Thanks!
MacBook Pro 13″, macOS 12.4
=sumifs(C; B; ">="&Date(2022;5;16); A; "<="&DATE(2022;6;14))
Once you posted your data I could see you are in a region that uses the comma as the decimal. In that case, you must use the semicolon as the argument delimiter in function. I am in the USA, so we use the period (".") as the decimal separator and, therefore, use the comma (",") as the argument separator for function.
I hope this helps,
Wayne
=sumifs(C; B; ">="&Date(2022;5;16); A; "<="&DATE(2022;6;14))
Once you posted your data I could see you are in a region that uses the comma as the decimal. In that case, you must use the semicolon as the argument delimiter in function. I am in the USA, so we use the period (".") as the decimal separator and, therefore, use the comma (",") as the argument separator for function.
I hope this helps,
Wayne
you can use the sumifs() function
sumif() would sum only is a single condition is true
sumifs() sums if all of the conditions are true
so for your case... you would want to have two conditions:
1) greater then or equal to the start date
2) less than or equal to the end date
assuming dates in column A and expenses in column B
something like this:
=sumifs(B, A, ">=6/15/2022", A, "<=7/14/2022")
maybe like this:
That sounds like what I've been looking for, but now I can't figure out how to actually write the formula. So If I just want it to calculate the sum from May 16 2022 to June 14 2022, how would I write that then? Sorry, totally new to this. And thanks so much for your help!
THANK YOU! Yes, that was the problem! And I now also managed to transfer the formula to other budget lists with different table names. Thanks so much for your help!
did any of the posts I made SoLVE your problem?
SUM formula needed for specific date ranges
