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
When adding in the indirect i either get errors and refs or it just wont work at all![]()
=COUNTIFS(Sheet1!A:A,E2,Sheet1!CC:CC,F1)
all i want to change is the CC:CC to the named range of one cell named col.
I am now at a loss.![]()
=COUNTIFS(INDIRECT("'Sheet1!A:A,E2,Sheet1!"&col&":"&"col"&",F1")
Bookmarks