Countifs and Indirects and get them to mix

[swifty1234]

Hi and thank you in advance for your help

I have used both countifs and indirects seperatly with total success when trying to combine them i am having trouble. below is the basic countifs which works

Please Login or Register  to view this content.

When adding in the indirect i either get errors and refs or it just wont work at all

all i want to change is the CC:CC to the named range of one cell named col.

Please Login or Register  to view this content.

I am now at a loss.

[JYTS]

Your COUNTIFS has only one argument, which is why it won't work. You need to put the indirect between the commas:

=COUNTIFS(Sheet1!A:A,E2,INDIRECT("Sheet1!"&"col"&":"&"col"),F1)

[swifty1234]

You my friend have been awesome that worked first time!!!