Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Identifying exact values in alternate rows | Excel Worksheet Functions |