Thread: SumProduct for select to the last cell that contains data???
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mniccole mniccole is offline
external usenet poster
  
Posts: 13
Default 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""))"

Reply With QuoteReply With Quote