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??

nRows range within SUMIF
 

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" wrote in message
...
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??