Forum Discussion

Jon_Morgan1958

Copper Contributor

Apr 10, 2020

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 name...

excel

Riny_van_Eekelen

Platinum Contributor

Apr 10, 2020

Jon_Morgan1958

That would be:

=(SUMIFS(Amount,Group,"Shopping",Date,">="&Apr_Start,Date,"<="&Apr_End))*-1