| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use the IF formula to total certain items in a column?
In column B1, I would like the total of all items in column E that correspond
with the same code from column A that is in column D. Column A is the total column, column D is the breakdown per employee. A B C D E F 200220 300320 4.00 300310 500310 39.25 300320 300320 5.00 300330 300330 9.75 300340 300310 20.00 400310 300330 19.00 500310 300330 8.00 600310 300330 8.00 700310 300320 4.66 700320 300320 28.25 800310 300320 28.25 900110 300340 36.00 0.00 0.00 500310 31.25 0.00 600310 38.50 300320 4.50 300320 4.50 300320 18.40 300320 4.50 300320 4.50 TOTAL 316.31 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to make a running total for three different items | Excel Worksheet Functions | |||
| Total different items from one column with reference to another? | Excel Discussion (Misc queries) | |||
| Formula to total items from a drop list with values in several col | Excel Discussion (Misc queries) | |||
| How can I show the total sum of items in a filtered column | Excel Worksheet Functions | |||
| XL formula - total of row = total of column | Excel Worksheet Functions | |||
Threaded Mode
