How to count reference stored daily to a sheet storing weekly.
I have a sheet that stores records daily (several per day) of installations categorized as either "Res" or "Com".
I'm trying to count the "Res" category above based on week ending dates (Sat) below in "Meters Installs Actuals (RES)".
So for Week Ending 01/14/24 the formula would count all Res from 01/08/24 to 01/14/24. I've tried several variations of the following formula,
=COUNTIFS({Field Production Report 2024 Range Res/Com}, "Res", <=[Week Ending]@row { Field Production Report 2024 Range Install DT }, >([Week Ending]@row - 7))))
Any help would be appreciated! Thank you...
Best Answer
-
You are close, just need to define your parameters a little differently.
=COUNTIFS({Field Production Report 2024 Range Res/Com}, "Res", { Field Production Report 2024 Range Install DT },AND(@cell >[Week Ending]@row - 7,@cell<=[Week Ending]@row))
Answers
-
You are close, just need to define your parameters a little differently.
=COUNTIFS({Field Production Report 2024 Range Res/Com}, "Res", { Field Production Report 2024 Range Install DT },AND(@cell >[Week Ending]@row - 7,@cell<=[Week Ending]@row))
-
@JamesB It all works as intended! Thank you very much for the help...
Help Article Resources
Categories
Check out the Formula Handbook template!