LinkBack URL
About LinkBacks
Hello,
I downloaded the attached file but accidentally deleted the formulas, I searched the forum in order to avoid this posting but wasn't successful.
Would appreciate if you can assist in providing the formula or link of original threat.
Thanks.
Consolidate - Payroll Staff
Hello,
I downloaded the attached file but accidentally deleted the formulas, I searched the forum in order to avoid this posting but wasn't successful.
Would appreciate if you can assist in providing the formula or link of original threat.
Thanks.
The formula (sumproduct).
I should go for the pivot table soluition (also added).
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Formula solution
c3=SUMIFS($B$13:$B$23,$C$13:$C$23,C$2,$D$13:$D$23,$B3)This is for your attached excel file
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
@nflsales: Thank you ... lesson learned for future use.
You guys are awesome!
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks