Godders199
Active Member
- Joined
- Mar 2, 2017
- Messages
- 313
- Office Version
- 2013
Hello, I have been reading on the internet that there is a previous quarter function, but cannot find any examples of how this works to amend my formula.
currently my formula is
=COUNTIFS(Outcomes!$D:$D,PRISM_LINKS!$B3,Outcomes!$U:$U,"issue identified - wrong customer outcome",Outcomes!$AK:$AK,Summary!$B$3)
Outcomes AK, currently works out the quarter , summary B3 is the quarter it should be counting.
So currently we are in quarter 4, so it should only counts rows meeting the criteria for quarter 3
Effectivety, I want to change the last element of this formula ",Outcomes!$AK:$AK,Summary!$B$3" to use the previousquarter function. The date field it should be looking at is in Outcomes AJ:AJ
Not sure if this is possible , if yes any assistance would be appreciated.
currently my formula is
=COUNTIFS(Outcomes!$D:$D,PRISM_LINKS!$B3,Outcomes!$U:$U,"issue identified - wrong customer outcome",Outcomes!$AK:$AK,Summary!$B$3)
Outcomes AK, currently works out the quarter , summary B3 is the quarter it should be counting.
So currently we are in quarter 4, so it should only counts rows meeting the criteria for quarter 3
Effectivety, I want to change the last element of this formula ",Outcomes!$AK:$AK,Summary!$B$3" to use the previousquarter function. The date field it should be looking at is in Outcomes AJ:AJ
Not sure if this is possible , if yes any assistance would be appreciated.
