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. |
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) |