Ok, I am trying to do a formula that will count a range (say A1:A6) if another range (B1:B6) has specific text (HI for example) in it. I have tried COUNTIF, COUNTA, COUNTIFS and a couple ofthers and I am stumped.
Untitled-3.jpg
Above is the example, this is what I want it to look like:
Untitled-4.jpg
Any ideas on what formula will do this???
Thanks in advance for helping!
Bookmarks