WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions?

  • Thread starter Thread starter Etien
  • Start date Start date
E

Etien

Hi there,

Is there a way to get WorksheetFunction.CountIf and .SumIf to work wit
2 conditions?

I know how to use

SUMPRODUCT((xRg/aCondition)*(yRg/bCondition))

and

SUMPRODUCT((xRg/aCondition)*(yRg/bCondition)*(zRg to count))

in Excel, but could not find a way to translate this into VBA code...


Thanks a lo
 
Etien,

SUMPRODUCT won't work as a worksheetfunction, you need to evaluate the
formula

Evaluate("=SumProduct((A1:A3 =""X"")*(B1:B3=""Y""))")


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Works great!

It was a bit tough to include my range variables (!) in there, but i
works now.

Thanks a lo
 
Back
Top