This worked. I have another challenge, which is an advanced version of this question.
Instead of having the tagging in one single column, every month has a different tagging.
"Use Jan Tagging Column for Jan Var, and use Feb Tagging Column for Feb Var". But we still need to SUMIF by Lapse in each of these Tagging Columns E and F.
I am also including another column for PY ACV, in addition to Jav var and Feb Var. The only difference is that PY ACV will be all customers with PY ACV number, whether lapsed or not. Please see attached updated file.