Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Like to sum revenue dependent on the value of two other columns of data.
So I would like a revenue total for all deals by rep x in the month of jan. The first column would be the month field. The second column would be the detail of orders by rep. The rep could have one or multiple listings. The 3rd column would have the revenue associated with that rep for that specific order. How do i set it up so the ouput looks for Jan only and rep x only. Then however many rows that may be, sum the revenue values? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF and SUMPRODUCT help needed | Excel Discussion (Misc queries) | |||
Min/Max help needed with a SumProduct | Excel Worksheet Functions | |||
Sumproduct Help Needed | Excel Discussion (Misc queries) | |||
SUMPRODUCT help needed | Excel Worksheet Functions | |||
Sumproduct help needed! | Excel Worksheet Functions |