Probably a vlookup type ? not sure

[Brian]

trying to track overtime. Employees broken up into sections a,b,c,d, and
then section a and section b are each have subsections broken up into 1,2,3
and c and d section each have 4,5,6 for subsections.

?: when an employee does overtime, they are entered under the A column
starting of course in A2 and working down. in B2 is entered the section
let's say C and then in C2 is entered their subsection, let's say for C we
use 4. Now in Col. D is the amount of hours that employee worked OT. On a
seperate sheet called "report" I want to show how many hours of overtime
occurred for each Section (ex: D section) and then also show how many hours
for the Section and subsection together (ex: D1, which means hours for D
section again but specifically for subsection 1 of D section.).

I would appreciate any help
Thank you,
Brian

 

[Bob Phillips]

=SUMIF(Sheet1!B:B,"D",Sheet1!D)

for the overtime

=SUMPRODUCT(--(Sheet1!B2:B200="D"),--(Sheet1!C2:C200=4),D2200)

(I used D4 as D can't have a sub-section 1 <g>)

SUMPRODUCT cannot use whole columns as SUJMIF can.

--


HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Brian]

thanks for your help and for catching my mistake (you'd think I would know my
own work schedule, still asleep I guess) Thanks again.