Hi, trying to get one cell to give a value depending on the displayed content of a list box within another cell.
If the list box cell shows “Admin” then the cell should show 1. Easy enough.
But I’m stuck when I try to get the same cell to count how many times “Admin” appears in many list boxes in a column.
Tried using
=IF(C:C=”Admin”,1,)
But this just shows if “Admin” appears in the particular row of the same cell?
I know this doesn’t count how many times “Admin” appears in the column either but I’m stuck on that part as well.
Appreciate any help with this.
