COUNTIFS not generating the correct output
I am trying to use this formula to COUNTIFS([Restaurant_Lounge]:[Restaurant_Lounge], >0, Status:Status, "Live", Vendor:Vendor, "VendorName") to get information from 3 different columns.
The Restaurant_Lounge column has blanks, numbers, and letters in it.
The Status:Status has a dropdown with various statuses.
Vendor:Vendor has a dropdown with various vendors in it.
What I am trying to do is get a sum of the numbers in the restaurant_lounge column, that are Live and has the VendorName specified.
I keep getting a very random number that I have no idea where it is coming from or even how it is being calculated.
I am new to this, so pretty much stumped and hoping for someone to shed some light on this one for me.
I appreciate any ideas you all may have.
Help Article Resources
Check out the Formula Handbook template!