So I am wanting to query a range in row with COUNT and COUNTIF queries. But I'm wanting to do this for one range in each row below, but the range reference is different in each rows.
I have manually set each range (96 of them/96 rows), but how do I avoid having to manually write/copy/paste the range ref into every new set of formulas for each new row?
In the picture below/attatched I am showing the formulas with the range set in upper rows. But I can't figure out how to automatically copy the range reference in the second coloumn into the COUNT/COUNTIF queries in the cells to its right.
Any help would be so massively appreciated.