nRows range within SUMIF

I've got a SUMIF formula in my macro code (see below) and need to specify a
range to include the 'nrows' (I have defined all of the bits in this formula
at the top of my code) but am having trouble with this...

Cells (nIrws, 21).Formula = "=SUMIF(G2:G nIRows,""<>CR"",U2:U nIRows)"

Any ideas? Would this work??

Cells (nIrws, 21).Formula = "=SUMIF(G2:G" & nIRows & ",""<>CR"",U2:U" &
nIRows & ")"


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Meltad" <[email protected]> wrote in message
news:[email protected]...
> I've got a SUMIF formula in my macro code (see below) and need to specify
a
> range to include the 'nrows' (I have defined all of the bits in this
formula
> at the top of my code) but am having trouble with this...
>
> Cells (nIrws, 21).Formula = "=SUMIF(G2:G nIRows,""<>CR"",U2:U nIRows)"
>
> Any ideas? Would this work??