Basically, it checks every other cell in C6:D42 for the value S, and picks
up the next cell value if true, and sums them.

--
__________________________________
HTH

Bob

"JEV" wrote in message
...
Thanks, Bob.
Can I trouble you to step me through this one. Having trouble following.

"Bob Phillips" wrote:

=SUMPRODUCT((MOD(COLUMN(C6:DQ42),2)=1)*(C6:DQ42="S "),(D6:DR42))

--
__________________________________
HTH

Bob

"JEV" wrote in message
...
In columns, I have a letter code (example "S" ) with a number across
from
it
in the next column. (each pair of columns is titled TYP and HRS) I want
to
sum all the numbers associated with a specific code. I have 60 pairs of
columns.
In a single formula, I'm trying to add 60 of the formula below,
substituting
the letters of the next 2 columns (i.e E & F, G & H...)
=SUMPRODUCT((C6:C42={S})*D6:D42)
Getting "formula too long" error. Can I get around this with another
approach?
Appreciate your guidance.