Sumif and Approval between 2 sheets

Simon Reynolds

Hi Everyone, Formulas are for sure not my greatest skillset :) looking for some advice on the formula for a calculation only if Approval for the request has been approved.
It's a simple time bank for overtime where the Supervisor /Manager can see if the person is in the plus/minus with overtime.

2 sheets
Time Bank Employee Information
=SUMIF({SLP Time Bank Team Member}, [Employee Name]1, {TB hours in the minus1})
=SUMIF({SLP Time Bank Team Member}, [Employee Name]1, {TB hours in the plus1})
Both formulas take added/removed hours from the request sheet and give the total , but right now it will add for both approved and declined

Time Bank Requests

Mark.poole

Change your Formulas to =SUMIFS()

What this does is give you the ability to use multiple criteria. Since I am unsure

ex.

=Sumifs({TB hours in the plus1},{SLP Time Bank Team Member}, [Employee Name]1,{Approval},"Approved")

=Sumifs({TB hours in the minus1},{SLP Time Bank Team Member}, [Employee Name]1,{Approval},"Approved")