If there is no pattern then you will have to do it manually...

"Mally" wrote:

Hi again Sheeloo

Thank you for your reply.

My problem is that there is no pattern to my formulas. The ranges are
different in every formula i.e. each individual row formula looks at a
different number of cells in a range. So thats why i can't copy it down a
column.

"Sheeloo" wrote:

Mally,
Sorry. I did not notice that the second formula was different...
Where are you copying these to? I mean which rows will have the formula in
row 2, which rows will have the formula in row 10, row13?
If the formulas follow the same pattern then enter thee formulas below in
the row indicated, select row 1-13 and drag down....

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


"Mally" wrote:

Hi Sheeloo

Thank you for your reply.

The ranges specified in the formulas are the ranges that i need so by taking
out the $ and copying the formulas will pick up the incorrect ranages.

Thank you again.