I copied all the info to one tab, as it's easier to make sure calculations are correct etc without having to flip between tabs. I suspect what you really need is a SUMPRODUCT formula, which one of the clever guys/gals here may yet provide, but in the absence of that, the following should work for you. This formula:
=SUMIF($B$2:$B$11,$S2,$K$2:$K$11)+SUMIF($C$2:$C$11,$S2,$L$2:$L$11)+SUMIF($D$2:$D$11,$S2,$M$2:$M$11)+SUMIF($E$2:$E$11,$S2,$N$2:$N$11)+SUMIF($F$2:$F$11,$S2,$O$2:$O$11)+SUMIF($G$2:$G$11,$S2,P2:P11)+SUMIF($H$2:$H$11,$S2,$Q$2:$Q$11)
in T2, and copied down, looks for the employees names, then sums the corresponding figure/s from the hours worked data.
So, what
=SUMIF($B$2:$B$11,$S2,$K$2:$K$11)
really says is, look in B2 to B11 for a match for the contents of S2, and sum the numbers from the corresponding cells in K2 to K11. Then I've just added extra cell ranges for the other days of the week.
Hope this helps.
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks