Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
martin
 
Posts: n/a
Default 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
  #3   Report Post  
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 08:11 PM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 11:05 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 11:56 PM
Copying Rows when hiding other rows Neutron1871 Excel Worksheet Functions 2 November 4th 04 12:38 AM
Identifying exact values in alternate rows YG Excel Worksheet Functions 1 November 3rd 04 12:25 AM


All times are GMT +1. The time now is 08:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"