Sum Ifs formula to calculate everything in a certain stage each month IF that month is in the future
Hi. So this is the formula I currently have: =SUMIFS([month #]66:[month #]77, >=MONTH(TODAY()), Client66:Client77, Stage:Stage, "Stage 1 Prospecting")
The month # is 1-12 on each row for each monthly calculation of TCV , and then the Client is the actual monthly calculation. I am getting an invalid operation error. What I am trying to sum is the monthly calculation for the TCV, which is already calculated, IF the opportunity is in stage 1and the month is in the future. Please help :)
Help Article Resources
Check out the Formula Handbook template!