Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumProduct for select to the last cell that contains data???
Hi:
How would I change the formula below to go only the last row that contains data instead of setting a static range? Please help Thanks Worksheets("Menu").Range("C18").Formula = "=SUMPRODUCT((BillingHoldDetails!M2:M3000)*(Billin gHoldDetails!$A$2:$A$3000=""AP BILLING""))" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumProduct for select to the last cell that contains data???
Worksheets("Menu").Range("C18").Formula = _
"=SUMIF(BillingHoldDetails!$A:$A,""AP BILLING"",BillingHoldDetails!$M:$M)" -- --- HTH Bob (change the xxxx to gmail if mailing direct) "mniccole" wrote in message ps.com... Hi: How would I change the formula below to go only the last row that contains data instead of setting a static range? Please help Thanks Worksheets("Menu").Range("C18").Formula = "=SUMPRODUCT((BillingHoldDetails!M2:M3000)*(Billin gHoldDetails!$A$2:$A$3000=""AP BILLING""))" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumProduct for select to the last cell that contains data???
Thanks Bob...
Works perfect. Bob Phillips wrote: Worksheets("Menu").Range("C18").Formula = _ "=SUMIF(BillingHoldDetails!$A:$A,""AP BILLING"",BillingHoldDetails!$M:$M)" -- --- HTH Bob (change the xxxx to gmail if mailing direct) "mniccole" wrote in message ps.com... Hi: How would I change the formula below to go only the last row that contains data instead of setting a static range? Please help Thanks Worksheets("Menu").Range("C18").Formula = "=SUMPRODUCT((BillingHoldDetails!M2:M3000)*(Billin gHoldDetails!$A$2:$A$3000=""AP BILLING""))" |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Loop QUESTION to end of data range...
HI:
Can you tell me how to loop to the end of the data range without this being static? Please numrows = Range("A2", Range("A2").End(xlDown)).Rows.Count Range("A2").EntireColumn.Select For x = 1 To 3000 Thanks so much Bob Phillips wrote: Worksheets("Menu").Range("C18").Formula = _ "=SUMIF(BillingHoldDetails!$A:$A,""AP BILLING"",BillingHoldDetails!$M:$M)" -- --- HTH Bob (change the xxxx to gmail if mailing direct) "mniccole" wrote in message ps.com... Hi: How would I change the formula below to go only the last row that contains data instead of setting a static range? Please help Thanks Worksheets("Menu").Range("C18").Formula = "=SUMPRODUCT((BillingHoldDetails!M2:M3000)*(Billin gHoldDetails!$A$2:$A$3000=""AP BILLING""))" |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Loop QUESTION to end of data range...
see response to your later posting in a new thread.
-- Regards Roger Govier "mniccole" wrote in message oups.com... HI: Can you tell me how to loop to the end of the data range without this being static? Please numrows = Range("A2", Range("A2").End(xlDown)).Rows.Count Range("A2").EntireColumn.Select For x = 1 To 3000 Thanks so much Bob Phillips wrote: Worksheets("Menu").Range("C18").Formula = _ "=SUMIF(BillingHoldDetails!$A:$A,""AP BILLING"",BillingHoldDetails!$M:$M)" -- --- HTH Bob (change the xxxx to gmail if mailing direct) "mniccole" wrote in message ps.com... Hi: How would I change the formula below to go only the last row that contains data instead of setting a static range? Please help Thanks Worksheets("Menu").Range("C18").Formula = "=SUMPRODUCT((BillingHoldDetails!M2:M3000)*(Billin gHoldDetails!$A$2:$A$3000=""AP BILLING""))" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling a cell automatically when data is put in another cell. | Excel Worksheet Functions | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
Cell data format | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |