COUNFIF within a different sheet with dynamic range

[kacper887]

Hello,

I have one excel file with several sheets of data and one final sheet XYZ dedicated for reporting. I have one sheet named ABC and there is a dynamic range which will change in the future - the number of columns can be different per each update of the file. I want to do a COUNTIF within XYZ sheet, which will:

1) Serach for a particular text value (placed in A4 cell of XYZ) and show how many values we have;
2) Include changes of the range from sheet ABC (at this moment it is C1:FM1).


Thank you very much in advance for support.

 

[Special-K99]

If the range C1:FM1 will expand over time can't you just change it so it the range covers more than you expect, ie changing it to C100000:ZZ100000 will mean you won't have to change for quite some time (hopefully).