Forum Discussion
Solved
Ugh. I'm at my wits end. Trying to combine two formulas and I'm stuck.
Good morning! I am trying to count the number of vacancies in site GHI if the square footage (SF) is created by the use of a formula. But I want to do it as it is laid out on the attached. I ...
This may work for you if you've got access to FILTER.
=LET(sites,SITES!B3:B13,type,SITES!N3:N13,SF,SITES!P3:P13,filtered,FILTER(sites,(sites=$B$2)*(type=$B$12)*(ISFORMULA(SF))),ROWS(filtered))
This may work for you if you've got access to FILTER.
=LET(sites,SITES!B3:B13,type,SITES!N3:N13,SF,SITES!P3:P13,filtered,FILTER(sites,(sites=$B$2)*(type=$B$12)*(ISFORMULA(SF))),ROWS(filtered))You guys are amazing. I am in awe. It actually indices uncontrollable laughter to see this artistry at work. SMH. I'm at a loss. Thank you for your help.
OH, and I'll be back for more help soon! 😄
Glad I could help! Thank you for providing the sample workbook. That goes a long way in this forum in getting a quick solution (or three).
