Can you use countif +1?
I am creating a results report that is updated weekly. I have a ton of variables that we're monitoring based off the week (i.e. week 1, week 2, etc..
I am wondering if I can save time with the weekly updates by using a COUNTIF formula but always have it increase by 1.
By this I mean:
=COUNTIF(reference sheet week column "1") for the week 1 total. I'd love to be able to add some type of +1 functionality so I could apply this formula to the whole row and and the COUNTIF reference would automatically count the next number (i.e. week 2, week 3, etc..)
I hope this makes sense!!
Help Article Resources
Check out the Formula Handbook template!