Countifs using a cell reference

[JToddHubbard]

Hey all,

I guess I'm too much of a n00b because I can't grasp (or find) where this might have been answered already.

I'm creating a template where I will count certain conditions, but the criteria will change each week.

Example

A	B	C	D
Criteria	Count	Total	%
Campaign 1	352	=countifs(Z:Z,"badEmail",Y:Y,"Campaign 1")	%

<tbody>
</tbody>

How can I change the Campaign 1 in the formula to reference Cell A2? I'm writing this template for someone else to use & the info in Cell A2 will change each time they use the template & I'd rather not give them access to this table to make edits to the formulas.

Thanks in advance.

 

[Jonmo1]

Try

=countifs(Z:Z,"badEmail",Y:Y,A2)

 

[JToddHubbard]

Got hung up on the "" being needed for non-cell reference criteria. Worked perfectly!

Thanks!

 

[Jonmo1]

You’re welcome