Sir, I am trying to find an excel formula to sum and display cells based on unique values of a column. Below there are two tables first is the data table and second is the result. Not able to find a formula to get the second table from table1. Pls help.
Name | Dept | Job | Zone | Area | Mon | Tue | Wed |
George | Spices | GA | South | TN | 0 | 40 | 40 |
George | Spices | GB | South | TN | 20 | 40 | 20 |
Abby | Milk | A1 | West | MUM | 0 | 0 | 5 |
Abby | Milk | A2 | West | MUM | 0 | 10 | 0 |
Mike | Corn | Maddy | #N/A | #N/A | 230 | 70 | 0 |
Mike | Cement | Mux | #N/A | #N/A | 110 | 20 | 0 |
Mike | Roof | Rick | #N/A | #N/A | 0 | 0 | 30 |
Need Formula to get below table from above table | |||||||
Name | Zone | Area | Mon | Tue | Wed | ||
George | South | TN | 20 | 80 | 60 | ||
Abby | West | MUM | 10 | 5 | |||
Mike | #N/A | #N/A | 340 | 90 | 30 |