| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sum values in cells according to category
I wish to sum values in a column by category in a drop down list in another
column e.g. £ xx Stat x Trav y Stat xy Trav etc |
|
#2
|
|||
|
|||
|
Look at SUMIF in Excel Help.
-- HTH RP (remove nothere from the email address if mailing direct) "oscar" wrote in message ... I wish to sum values in a column by category in a drop down list in another column e.g. £ xx Stat x Trav y Stat xy Trav etc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| How do I sum up values only in cells that are color filled? | Excel Worksheet Functions | |||
| Formatting cells in Excel for certain Values to appear certain Col | Excel Worksheet Functions | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
| How to add a button to restore all altered cells original values? | Excel Discussion (Misc queries) | |||
Linear Mode
