SUMPRODUCT FORMULA EXCEL 2003
 

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.

SUMPRODUCT FORMULA EXCEL 2003
 

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

SUMPRODUCT FORMULA EXCEL 2003
 

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

SUMPRODUCT FORMULA EXCEL 2003
 

On Fri, 23 Jan 2009 20:50:56 GMT, Lars-Åke Aspelin
wrote:

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

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

Lars-Åke

SUMPRODUCT FORMULA EXCEL 2003
 

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.

SUMPRODUCT FORMULA EXCEL 2003
 

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.