Hello.
Currently have a list of accounts that each have multiple invoices for each account.
Need to know how many total accounts had a fence removed and how many have no fence.
Current formula I am working with is:
=SUM(IF(FREQUENCY(IF(F:F="-",B:B),B:B)>0,1))
That gives me the total for those that never had a fence. But how do I also ask it to also count the cells labeled as "RMVD" in the same column? (F:F)
Thank you!
Currently have a list of accounts that each have multiple invoices for each account.
Need to know how many total accounts had a fence removed and how many have no fence.
Current formula I am working with is:
=SUM(IF(FREQUENCY(IF(F:F="-",B:B),B:B)>0,1))
That gives me the total for those that never had a fence. But how do I also ask it to also count the cells labeled as "RMVD" in the same column? (F:F)
Thank you!