Sumifs to return PTO or Sick time totals

JMcNeil

So I have my employees filling out a form where they can request the amount of time that they want off and the type of time (PTO, Sick, or unpaid) I am trying to pull the data from that sheet into a master tracker. So I'm trying to add the numbers from (# time off requested column)but only add the numbers if the employee name matches and the type of PTO chosen matches. I've tried a few variations of the formula below but nothing is working.

=SUMIFS({PTO and Absence Tracking Range 4}, {PTO and Absence Tracking Range 6}, =Employee@row , {PTO and Absence Tracking Range 7}, ="Sick Day")

Paul Newcome

Are you getting an error message or a different than expected number with the formula above?