| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula Help
I have two colums. One contains Order#, the other the $ amount the of a
discount. If an order has 5items in it, the Order# appear in column A 5 times with the associated discount for each item. I want to calculate the total discount by Order#. Data: Full Order # Difference P10890950001 -$5.00 P10962970001 -$13.00 P10948610001 -$25.00 P10948610001 -$15.00 P10731350001 -$10.00 P10731350001 -$4.50 P09494270003 -$20.00 P10878810001 -$12.29 P10866140001 -$39.47 P09604470002 -$22.00 P10895690001 -$6.00 P10895690001 -$6.00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Threaded Mode
