| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
| SumIf - when I fill down the Range, Criteria & sum range changes | Excel Worksheet Functions | |||
| Sumif range? | Excel Worksheet Functions | |||
| How to use a range in SUMIF? | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Linear Mode
