| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
help me getting value of column based on condition
heloo help me in that please if i have these 2 coulmns 1 1000 2 1222 3 200 1 100 2 200 3 300 4 400 i want to calculate how many 1 appears and the total of all value in the second colum in 1 so the results will be 2 times 1000+100=1100 please tell me in details how to do that, -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=484555 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How do I sum a column based on another column | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| Count cells based on date range in another column | New Users to Excel | |||
Threaded Mode
