Thread: Sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default 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 ***