Excel Sumif references

%3CLINGO-SUB%20id%3D%22lingo-sub-2036543%22%20slang%3D%22en-US%22%3EExcel%20Sumif%20references%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2036543%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20100%25%20self%20taught%20on%20Excel%20via%20trial%20and%20error%20and%20a%20few%20visits%20to%20Youtube.%3C%2FP%3E%3CP%3EI%20have%20built%20a%20cashflow%20projection%20sheet%20which%20looks%20at%20data%20populated%20on%20tabs%20and%20pulls%20them%20through%20to%20a%20tab%20that%20shows%20cash%20in%20and%20cash%20out%20month%20on%20month%20per%20item%20type.%20For%20example%20Material%20Spend%20January%20and%20March%2C%20Sud%20Contractor%20Spend%20January%20and%20June.%3C%2FP%3E%3CP%3EI%20have%20done%20this%20by%20using%20the%20following(With%20the%20dates%20changing%20in%20each%20corresponding%20month%20column)%3C%2FP%3E%3CP%3E%3DSUMIFS('Advanced%20Payment'!%24F%243%3A%24F%24488%2C'Advanced%20Payment'!%24E%243%3A%24E%24488%2C%22%26gt%3B%3D01%2F01%2F2020%22%2C'Advanced%20Payment'!%24E%243%3A%24E%24488%2C%22%26lt%3B%3D31%2F01%2F2020%22)%3C%2FP%3E%3CP%3EHowever%20I%20would%20like%20to%20get%20the%20date%20variable%20to%20look%20at%20and%20reference%20a%20value%20within%20a%20cell%20to%20enable%20me%20to%20put%20in%20a%20new%20start%20month%20and%20get%20the%20sheet%20to%20be%20updated%20via%20changing%20one%20set%20of%20dates%20in%20one%20row%20rather%20than%20going%20into%20every%20single%20cell%20and%20changing%2001%2F01%2F2020%20to%2001%2F01%2F2021.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20get%20%22%26gt%3B%3D01%2F01%2F2020%22%20to%20look%20at%20a%20specific%20cell%20and%20reference%20a%20value%20within%3F%20For%20example%20if%20I%20put%2001%2F01%2F2020%20in%20cell%20C4%20then%20%22%26gt%3B%3D%20Contents%20of%20C4%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2036543%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am 100% self taught on Excel via trial and error and a few visits to Youtube.

I have built a cashflow projection sheet which looks at data populated on tabs and pulls them through to a tab that shows cash in and cash out month on month per item type. For example Material Spend January and March, Sud Contractor Spend January and June.

I have done this by using the following(With the dates changing in each corresponding month column)

=SUMIFS('Advanced Payment'!$F$3:$F$488,'Advanced Payment'!$E$3:$E$488,">=01/01/2020",'Advanced Payment'!$E$3:$E$488,"<=31/01/2020")

However I would like to get the date variable to look at and reference a value within a cell to enable me to put in a new start month and get the sheet to be updated via changing one set of dates in one row rather than going into every single cell and changing 01/01/2020 to 01/01/2021.

Is there a way to get ">=01/01/2020" to look at a specific cell and reference a value within? For example if I put 01/01/2020 in cell C4 then ">= Contents of C4"?

 

 

0 Replies