Hey everyone, having a big issues with a report I'm working on.
I have columns that people input data into the cells using a dropdown that lists out:
yes
no
n/a
I'm trying to count the number of yes and no in my columns. I'm using =COUNTIF(my cell range, "yes) and =COUNTIF(my cell range, "no")
It's counting the yes' correctly but not counting and 'no's. It's the same formula so I'm really confused on why it's not adding up one item correctly.
Any help??
I have columns that people input data into the cells using a dropdown that lists out:
yes
no
n/a
I'm trying to count the number of yes and no in my columns. I'm using =COUNTIF(my cell range, "yes) and =COUNTIF(my cell range, "no")
It's counting the yes' correctly but not counting and 'no's. It's the same formula so I'm really confused on why it's not adding up one item correctly.
Any help??