Need help with COUNTIFS

[ashley8200]

Can you use a cell reference in a countifs formula?
I am making a spreadsheet where users will fill in a list of names and I want to make a forumula that will countif one of those names is selected + if a checkbox is marked true = to equal one.

So far I've got this as an example:
=COUNTIFS(E5:E23,"?",A5:A23,TRUE)

Is there something I can put in the quotation marks to reference a cell that the user filled in?

Thanks so much for your help!

 

[Jonmo1]

Welcome to the board.

No quotation marks, just put the cell reference..

=COUNTIFS(E5:E23,A1,A5:A23,TRUE)

A1 is the cell the user types in a name to test for.

 

[SteveO59L]

try posting a sample of your data, and what you would like to do with it

 

[ashley8200]

Oh my goodness, it was that easy? I feel like a doofus.

Thanks for your help!

 

[AlanY]

Oh my goodness, it was that easy? I feel like a doofus.

don't worry, we all been there before.

 

[Jonmo1]

You're welcome.