Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello:
I have the following SUMPRODUCT formula in a worksheet cell: =SUMPRODUCT((MYSHEET!$P$12:$P$999="RR")*(MYSHEET!$ V$12:$V$999<"OPEN")*(MYSHEET!$AL$12:$AL$999)) I am trying to recreate this formula in VBA using the Evaluate or WorksheetFunction feature, but am running into problems. How can I recreate this formula in VBA. "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Excel 2002,
Evaluate("SUMPRODUCT((MYSHEET!$P$12:$P$999=""RR"") *(MYSHEET!$V$12:$V$999<""OPEN"")*(MYSHEET!$AL$12: $AL$999))") works for me. Maybe you weren't using the double double-quotes ("") to indicate the " character within the string. "SowBelly" wrote: Hello: I have the following SUMPRODUCT formula in a worksheet cell: =SUMPRODUCT((MYSHEET!$P$12:$P$999="RR")*(MYSHEET!$ V$12:$V$999<"OPEN")*(MYSHEET!$AL$12:$AL$999)) I am trying to recreate this formula in VBA using the Evaluate or WorksheetFunction feature, but am running into problems. How can I recreate this formula in VBA. "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ryan:
Looks like this was the problem. Oink! SowBelly On Thu, 26 Aug 2004 22:39:04 -0700, Ryan Poth wrote: Using Excel 2002, Evaluate("SUMPRODUCT((MYSHEET!$P$12:$P$999=""RR"" )*(MYSHEET!$V$12:$V$999<""OPEN"")*(MYSHEET!$AL$12 :$AL$999))") works for me. Maybe you weren't using the double double-quotes ("") to indicate the " character within the string. "SowBelly" wrote: Hello: I have the following SUMPRODUCT formula in a worksheet cell: =SUMPRODUCT((MYSHEET!$P$12:$P$999="RR")*(MYSHEET!$ V$12:$V$999<"OPEN")*(MYSHEET!$AL$12:$AL$999)) I am trying to recreate this formula in VBA using the Evaluate or WorksheetFunction feature, but am running into problems. How can I recreate this formula in VBA. "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.WorksheetFunction.Match problem | Excel Worksheet Functions | |||
Problem using "Find" WorksheetFunction in Excel VBA | Excel Programming | |||
WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions? | Excel Programming | |||
WorksheetFunction | Excel Programming | |||
worksheetfunction | Excel Programming |