Thread: WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Etien[_2_] Etien[_2_] is offline
external usenet poster
  
Posts: 1
Default WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions?
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

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote