Question

Locked

Excel formula

By Dodster ·
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.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Here you go

by neilb@uk In reply to Excel formula

This will count the number of times that Admin appears in cells A1->A10

=COUNTIF(A1:A10,"Admin")

To display the content match for a single cell, say, enter =IF(A1="Admin",1,"") in cell B1 and just copy it down the column. Does that do what you want?

Neil :)

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums