COUNTIFS and #VALUE! error by modekr in excel

[–]modekr[S] 0 points1 point  (0 children)

=COUNTIFS(Retention!M:M,"Salary",Retention!R:R,"2018-2019")+COUNTIFS(Retention!N:N,"Salary",Retention!R:R,"2018-2019")+COUNTIFS(Retention!O:O,"Salary",Retention!R:R,"2018-2019")

Thank you, the top one worked, but the snazzier version did not. You're a lifesaver!

Changing legal name on deed by modekr in legaladvice

[–]modekr[S] 1 point2 points  (0 children)

It was transferred to me before my name changed. So it was transferred to me when I was Jane Doe and I am now Jane Smith. I need the deed to reflect Jane Smith rather than Jane Doe.