View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rachel[_5_] Rachel[_5_] is offline
external usenet poster
 
Posts: 2
Default Custom Function-sum based on multiple criteria

I have created a custom function that sums one range of
cells based on criteria in another range:

dblIBilling = Application.WorksheetFunction.SumIf
(OwnerRange, employee, BillingsRange)

Now I need to add two additional criteria from a different
range.

In essence:
Sum "BillingsRange" if "OwnerRange" = employee's name (the
part I already have)
AND
"UnitsRange" = "Hour" or "Over".

I'm sure this can be done, and I've tried multiple options
but I'm not getting it.

Any advise would be appreciated!
Rachel