I have a worksheet that is tracking items that are missed broken down daily
by employee... The columns look like:
A2 (date) B2 (Name) C2 (Initials) D2 (# of items)
Same as above for: F2 G2 H2 I2
then the running tally in K2 (name) L2 (Initials) M2 (Running total)

I've tried two different formulas with no result but the horrid ####'s.

=SUMPRODUCT(--($C$2:$C$31="TLG"),--($H$2:$H$31="TLG"),--($D$2:$D$3),--($I$2:$I$31))
and
=SUMPRODUCT(--(C$2:C$31:H$2:H$31="TLG"),--(D$2:D$31:I$2:I$31))

Help??

Tia