Hi, Can anyone help with this complex formula??
Two Goals:
1) SUMIF - Column C = Specific Dept, Add the total in column H (This part I know, but then I need to add date considerations for part 2)
2) Compute quarterly salary expense by Hire date: ie: if hired in column D - Calculate the total salary expense in H for Q2 2023 per department.
Thanks for the help!!
This proposal adds a column (I) to the source data.
Column I is populated using: =H3*DAYS(I$2,MAX(I$1,D3))/DAYS(DATE(YEAR(TODAY()),12,31),DATE(YEAR(TODAY()),1,1))
Note that cells I1:I2 contain the start and end dates of Q2 2023 respectively.
The total salary expense per department is in column N: =SUMIFS(I$3:I$6,C$3:C$6,M1)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks