I'm trying to help my wife with a formula. She needs to count how many people are leasing apartments, which are denoted in the tab "1 - Test". I'm trying to count how many people are in column B. I just labeled everyone with the same name for this example. And then I'm trying to find out how many total units there are, which are in column A. Some are vacant which is the difference between columns A and B. But if you look at my formulas in the dashboard, I'm using the CountIf formula. Both are returning 0 though. What am I doing wrong?
Thanks.
Bookmarks