Forum Discussion

Copper Contributor

Sep 19, 2022

Solved

Table Formula

Hi All,

Need help with a formula for tables. What u need on the sheet is to have on the "Time Off Earned" sheet is to have cell C2 withdrawal the sum of sheet "Time Off Requested" under Time Approved based off of criteria Employee Name and Pay Code. Thank you for any help!

https://1drv.ms/x/s!Agmju254hK9cgj3h0Og1eZF_bXml

excel

Formulas and Functions

dscheikey
Sep 19, 2022
Bahama85
I have added some SUMIFS() functions to your table. Is that what you wanted?
=SUMIFS(Table1[Time Approved],Table1[Employee Name],[@Employee],Table1[Pay Code],Table4[[#Headers],[Personal Time]])

1 Reply

dscheikey
Bronze Contributor
Sep 19, 2022
Bahama85
I have added some SUMIFS() functions to your table. Is that what you wanted?
=SUMIFS(Table1[Time Approved],Table1[Employee Name],[@Employee],Table1[Pay Code],Table4[[#Headers],[Personal Time]])