On Fri, 23 Jan 2009 12:31:01 -0800, JEV
wrote:

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.


Try this modfied formula:

=SUMPRODUCT((C6:C42="S")*(D6:D42))

Hope this helps / Lars-Åke