Use cell text in COUNTIFS formula referring to a Table

[brucesw]

I'm counting cells with matching criteria (Blanks) in various Table columns using COUNTIFS as follows in column B; =COUNTIFS(Table1[[#All],[Issue Priority]],"")

The Field/Column "Issue Priority" is in column A and there are many different names down column A. I want to make my formula dynamic and copy down col B referring to the names in col A.

I think I should use INDIRECT but I can't get it right.
=COUNTIFS(Table1[[#All],[INDIRECT(A2)]],"")

I'd love help on a seemingly simple question. Thanks,

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you are counting blank cells, I'm not sure what the value in A2 has to do with it.
Or are you trying to count how many times the name in col A occurs?

 

[brucesw]

Thanks for the feedback,
More info;

Cell A2 contains text "Issue Priority" and the relevant formula in B2 is =COUNTIFS(Table1[[#All],[Issue Priority]],"")

A3 has "Category", I want the COUNTIFS formula copied from B1 to B2 to refer to the Category field. Like =COUNTIFS(Table1[[#All],[Category]],"") but dynamic as I have 30 more to reference.

I hope that helps you help me.

 

[brucesw]

Got it;
=COUNTIFS(INDIRECT("Table1[[#All],["&A2&"]]"),"")

 

[Fluff]

Glad you sorted it & thanks for letting us know.