Sumproduct
 

Hi there,

row 1 has either Section I or Section II in it
Row 2 has numbers

both rows run from A to BY

In BZ I need to sum all section I
In CA I need to sum all section II

Eg

a1 section I
a2 10

b1 section II
b2 5

c1 Section II
C2 8

so sum of section II should be 13

Thanks!!!!

Darin

*** Sent via Developersdex http://www.developersdex.com ***

Sumproduct
 

=SUMIF(A1:BY1,"Section I",A2:BY2)
=SUMIF(A1:BY1,"Section II",A2:BY2)

--
HTH,
Bernie
MS Excel MVP


"Darin Kramer" wrote in message
...


Hi there,

row 1 has either Section I or Section II in it
Row 2 has numbers

both rows run from A to BY

In BZ I need to sum all section I
In CA I need to sum all section II

Eg

a1 section I
a2 10

b1 section II
b2 5

c1 Section II
C2 8

so sum of section II should be 13

Thanks!!!!

Darin

*** Sent via Developersdex http://www.developersdex.com ***

Sumproduct
 

Thanks Bernie!

*** Sent via Developersdex http://www.developersdex.com ***