In table format

code hrs code hrs code hrs total
10 8 20 8 42 10 16
12 6 11 1 40 8 15
I need to sum hrs where the code does not equal 42 for each row. What is the
best way to accomplish task?
--
Bonita

=SUMPRODUCT(--($B$1:$F$1="hrs"),--(A2:E2<42),(B2:F2))

With nice headers in row 1.

Notice how the headers look at B:F, but the codes look at A:E, and we sum B:F.



Bonita wrote:

In table format

code hrs code hrs code hrs total
10 8 20 8 42 10 16
12 6 11 1 40 8 15
I need to sum hrs where the code does not equal 42 for each row. What is the
best way to accomplish task?
--
Bonita

--

Dave Peterson

Thanks!!!
--
Bonita


"Dave Peterson" wrote:

=SUMPRODUCT(--($B$1:$F$1="hrs"),--(A2:E2<42),(B2:F2))

With nice headers in row 1.

Notice how the headers look at B:F, but the codes look at A:E, and we sum B:F.



Bonita wrote:

In table format

code hrs code hrs code hrs total
10 8 20 8 42 10 16
12 6 11 1 40 8 15
I need to sum hrs where the code does not equal 42 for each row. What is the
best way to accomplish task?
--
Bonita

--

Dave Peterson