Summing all rows with certain specification
 

Dear all,

How is it possible to Sum up all A column figures which have d column set to
"Including" ? Thanks.
A B C D
1)15 200 36000 Including
2)50 250 150000 Exlcuding
3)500 210 1260000 Including
4)15

5)150 230 414000 Exlcuding
6)200 220 528000 Including

7)300 250 900000 Including

8) 50 100 60000 Including

9) 30 500 180000 Including
10) 30 350 126000 Including
11) 30 150 54000 Including
12) 50 200 120000 Exlcuding

Several ways
look in help index for SUMIF
=sumproduct((d2:d200="including")*a2:a200)
datafilterautofilter look in help index for SUBTOTAL

--
Don Guillett
SalesAid Software

"martin" wrote in message
...
Dear all,

How is it possible to Sum up all A column figures which have d column set
to
"Including" ? Thanks.
A B C D
1)15 200 36000 Including
2)50 250 150000 Exlcuding
3)500 210 1260000 Including
4)15

5)150 230 414000 Exlcuding
6)200 220 528000 Including

7)300 250 900000 Including

8) 50 100 60000 Including

9) 30 500 180000 Including
10) 30 350 126000 Including
11) 30 150 54000 Including
12) 50 200 120000 Exlcuding

at A13 enter:

=SUMIF(C1:C12,"Including",A1:A12)

-----Original Message-----
Dear all,

How is it possible to Sum up all A column figures which
have d column set to
"Including" ? Thanks.
A B C D
1)15 200 36000 Including
2)50 250 150000 Exlcuding
3)500 210 1260000 Including
4)15

5)150 230 414000 Exlcuding
6)200 220 528000 Including

7)300 250 900000 Including

8) 50 100 60000 Including

9) 30 500 180000 Including
10) 30 350 126000 Including
11) 30 150 54000 Including
12) 50 200 120000 Exlcuding
.