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
|