=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.