| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I sumif using 3 reference columns?
I want to show sales by salesperson. By using the worksheet format below I
want to sum column L if column I = salesperson and column N = Sales status of sold. ColumnI ColumnL ColumnN Salesman $ Amount Status DP 14000 S DP 20000 P PR 1000 L Any help would be very appreciated. |
|
#2
|
|||
|
|||
|
Why do you repost?
tw5633 wrote: I want to show sales by salesperson. By using the worksheet format below I want to sum column L if column I = salesperson and column N = Sales status of sold. ColumnI ColumnL ColumnN Salesman $ Amount Status DP 14000 S DP 20000 P PR 1000 L Any help would be very appreciated. |
|
#3
|
|||
|
|||
|
I was searching for the Q & A and couldn't locate it, so I reposted 2 more.
Sorry. However, thank you very much for the support. "Aladin Akyurek" wrote: Why do you repost? tw5633 wrote: I want to show sales by salesperson. By using the worksheet format below I want to sum column L if column I = salesperson and column N = Sales status of sold. ColumnI ColumnL ColumnN Salesman $ Amount Status DP 14000 S DP 20000 P PR 1000 L Any help would be very appreciated. |
|
#4
|
|||
|
|||
|
http://tinyurl.com/9ndp8
tw5633 wrote: I was searching for the Q & A and couldn't locate it, so I reposted 2 more. Sorry. However, thank you very much for the support. "Aladin Akyurek" wrote: Why do you repost? tw5633 wrote: I want to show sales by salesperson. By using the worksheet format below I want to sum column L if column I = salesperson and column N = Sales status of sold. ColumnI ColumnL ColumnN Salesman $ Amount Status DP 14000 S DP 20000 P PR 1000 L Any help would be very appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns | Excel Discussion (Misc queries) | |||
| Reference Cells with Sumif or Countif | New Users to Excel | |||
| How do I reference non-contiguous columns in another sheet and th. | Excel Discussion (Misc queries) | |||
| Sumif over multiple columns | Excel Worksheet Functions | |||
| Formulas: Keeping same row/column reference when columns are inser | Excel Discussion (Misc queries) | |||
Linear Mode
