Help! I am trying to create a formula that counts how many customers without duplicates I have in column G, given that it has "PREM" in column W, and "00203" in column P.
I have been using this formula until I recently realized that there are dupliate accounts in column G, it worked well until then.
=SUMPRODUCT((W2:W4110<>" STD")*(P2:P4110<>"00201")*(P2:P4110<>"00202")*(P2:P4110<>"00204"))
I would also love to also include a "do not count empty spaces" too.
Please help, there might be another better formula to use but I am running out of ideas in this one.
Thanks!
Cristina
Bookmarks