SUMPRODUCT help

[TiaB]

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$31:I$2:I$31))

Help??

Tia

 

[Biff]

It depends on what you're trying to sum. If you use Sumproduct then both
criteria ranges, $C$2:$C$31 and $H$2:$H$31, must have "TLG" to get the sum:

.......C2.........D2..........H2...........I2
......TLG........10..........XX..........10

The above example would equal 0 because H2 does not contain TLG.

If that's really what you want try this:

=SUMPRODUCT(--(C2:C31="TLG"),--(H2:H31="TLG"),D231+I2:I31)

If you really want to sum ANY cells that correspond to "TLG" then try this:

=SUMIF(C2:C31,"TLG",D231)+SUMIF(H2:H31,"TLG",I2:I31)

Biff