Forum Discussion
SumIfs
Ver 2016
Hi I am using SumIf to return results matching criteria between 2 dates.
My formula is
(SUMIFS(Amount,Group,"=Shopping",Date,">=01/04/20",Date,"<=30/4/20"))*-1
I would like to use a named cell as the 2 dates ie “Apr_Start” “Apr_End”
I think my problem is a simple newbie syntax error but try as I might I cant find it.
My other question is as a newbie I am still exploring modern Excel, is this the best method to get my data please?
Jon
1 Reply
That would be:
=(SUMIFS(Amount,Group,"Shopping",Date,">="&Apr_Start,Date,"<="&Apr_End))*-1
