| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple arguments from 2 column to provide an added result from a
I am trying to find a solution to the following data - hav tried all sorts to
no avail BRANCH DEPT ACCOUNT TOTAL C SV 300 $450 W SV 310 $200 C PT 300 $500 W PT 300 $100 C SV 300 $ 50 C SV 310 $200 The list of data extends over about 5000 lines with many variations per column What i am want to determine is a formula that will tell me the total sum of the TOTAL column when it meets a certain criteria from the first 3 columns - ie what is the total $ where the branch is C - Department is SV - and the Account is 300 (answer is $450 + $50=$500) - any ideas please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple arguments from 2 column to provide an added result fr | Excel Worksheet Functions | |||
| Provide a match from 2 cells to give a result from another | Excel Worksheet Functions | |||
| Having a formula provide a running total from multiple worksheets | Excel Worksheet Functions | |||
| Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
| How do I Provide a specific result given multiple criteria? | Excel Worksheet Functions | |||
Threaded Mode
