SumIfs

%3CLINGO-SUB%20id%3D%22lingo-sub-1297650%22%20slang%3D%22en-US%22%3ESumIfs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1297650%22%20slang%3D%22en-US%22%3E%3CP%3EVer%202016%3C%2FP%3E%3CP%3EHi%20I%20am%20using%20SumIf%20to%20return%20results%20matching%20criteria%20between%202%20dates.%3C%2FP%3E%3CP%3EMy%20formula%20is%3C%2FP%3E%3CP%3E(SUMIFS(Amount%2CGroup%2C%22%3DShopping%22%2CDate%2C%22%26gt%3B%3D01%2F04%2F20%22%2CDate%2C%22%26lt%3B%3D30%2F4%2F20%22))*-1%3C%2FP%3E%3CP%3EI%20would%20like%20to%20use%20a%20named%20cell%20as%20the%202%20dates%20ie%20%E2%80%9CApr_Start%E2%80%9D%20%E2%80%9CApr_End%E2%80%9D%3C%2FP%3E%3CP%3EI%20think%20my%20problem%20is%20a%20simple%20newbie%20syntax%20error%20but%20try%20as%20I%20might%20I%20cant%20find%20it.%3C%2FP%3E%3CP%3EMy%20other%20question%20is%20as%20a%20newbie%20I%20am%20still%20exploring%20modern%20Excel%2C%20is%20this%20the%20best%20method%20to%20get%20my%20data%20please%3F%3C%2FP%3E%3CP%3EJon%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1297650%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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
Highlighted

@Jon_Morgan1958 

That would be:

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