Summing all rows with certain specification

[martin]

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

 

[Don Guillett]

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

 

[Guest]

at A13 enter:

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