SUMPRODUCT FORMULA EXCEL 2003

[JEV]

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})*D642)
Getting "formula too long" error. Can I get around this with another approach?
Appreciate your guidance.

 

[Lars-Åke Aspelin]

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})*D642)
Getting "formula too long" error. Can I get around this with another approach?
Appreciate your guidance.

Try this modfied formula:

=SUMPRODUCT((C6:C42="S")*(D642))

Hope this helps / Lars-Åke

 

[Bob Phillips]

=SUMPRODUCT((MOD(COLUMN(C6Q42),2)=1)*(C6Q42="S"),(D6R42))

 

[Lars-Åke Aspelin]

Try this modfied formula:

=SUMPRODUCT((C6:C42="S")*(D642))

Hope this helps / Lars-Åke

Sorry, disregard my post. I misunderstood what you tried to
accomplish.

Lars-Åke

 

[JEV]

Thanks, Bob.
Can I trouble you to step me through this one. Having trouble following.

 

[Bob Phillips]

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