perhap, try using Name range, such as
naming col N's data to its header and use the name in the formula.
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Mally" wrote:

I have the following formulas in my worksheet

Row 2 =SUMPRODUCT(($N2:$N9<$H2)*($O2:$O9<$G$1)*($N2:$N9 =$L2))
Row 10 =SUMPRODUCT(($N10:$N12<$H10)*($O10:$O12<$G$1)*($N1 0:$N12=$L10))
Row 13 =SUMPRODUCT(($N13:$N20<$H13)*($O13:$O20<$G$1)*($N1 3:$N20=$L13))

As you can see there are different ranges in the formulas. What I am doing
is copying the formulas into the relevant cells and manually changing the
ranges. Having over 3000 to do will take a lot of time!

Is there and easy way of copying the formula down the sheet to pick up the
ranges.

Each new range row is highlighted in TAN so I dont know if this could be
used to find the new range.

Any help would be appreciated.