Countif Indirect to look at cell range in different sheet

[pana8543]

Hi all,

I am trying to use the indirect function to specify the column letter in a countif statement but having issues on getting it working.

As per below screenshot, the column letter is specified in column E and then in column F, I have added the following formula:

=COUNTIFS(Sheet1!E3:E1486,$C$1,Sheet1!$N$3:$N$1486,"<0")

I would like to user the indirect function to replace the "N" with whatever letter is in column E.

Any help or guidance on this, would be greatly appreciated!

Thank you

 

[jasonb75]

This is how it should be written

=COUNTIFS(Sheet1!E3:E1486,$C$1,INDIRECT("'Sheet1'!"&E2&"3:"&E2&"1486"),"<0")

 

[pana8543]

Thank you so much, worked great!