Say I have 2 columns. One has various strings, say "dog" or "cat." The second column has various numbers, say "0" or "0.99."
How can I create a "countif" that match say both "cat" and "0.99." Google tells me that countif can not match multiple conditions, so I need to use a sum formula.
What I've got so far from another website is this formula, but it does not seem to be working.
I also triedPlease Login or Register to view this content.
Any ideas?Please Login or Register to view this content.
Bookmarks