| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is there a way to pick the cells to add using sum?
I have two columns, one is descriptions and one is totals.
I want to add certian totals depending on the description. ie.... A B 1 HL3 100 2 DLV 50 3 HL4 500 4 DLV 250 TOTAL DLV 300 TOTAL OF OTHERS 600 The DLV will always be the same, but the other descriptions will change. thanks for any help. Wally |
|
#2
|
|||
|
|||
|
Have a look in HELP index for SUMIF
-- Don Guillett SalesAid Software "WTG" wrote in message ... I have two columns, one is descriptions and one is totals. I want to add certian totals depending on the description. ie.... A B 1 HL3 100 2 DLV 50 3 HL4 500 4 DLV 250 TOTAL DLV 300 TOTAL OF OTHERS 600 The DLV will always be the same, but the other descriptions will change. thanks for any help. Wally |
|
#3
|
|||
|
|||
|
Thanks, :)
On Sat, 4 Jun 2005 08:19:49 -0500, "Don Guillett" wrote: Have a look in HELP index for SUMIF |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Pick a cell with highest value from a range of cells? | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
