I want to be able to count the number of times an item in column A have appeared in column B and bring the result in column C. But values from column A have been obtained using a formula so they are expected to change every time.
Eg:
Column A Column B Column C
Laptops Umbrella 2 Laptops
Phones Radios 0 Phones
Radios Laptop 3 Radios
Laptop
Radios
Radios
Column C will show only numbers don't bother about the words. Now is there a way I can select an item in the row as a reference for count if? Say COUNTIF(@Column B:B=ARRAY(@ColumnA:A)).
Long story short, how do I make it work?