| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum based on two conditions
Hello! Please help with data below - sum col B based on top 2 of col C and
group by Col A. T1=70+100=170, T2 = 400+300=700, T3=150+110=260 Thank you so much for helping. Col A Col B Col C T1 100 20% T3 150 15% T2 400 30% T1 400 10% T1 70 50% T2 120 18% T1 150 15% T2 300 30% T3 110 10% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging Cells Based On Conditions in Neighboring Cells | Excel Discussion (Misc queries) | |||
| Total or Count based on multiple conditions | Excel Discussion (Misc queries) | |||
| Add cells from a range based on 2 conditions from 2 other ranges | Excel Worksheet Functions | |||
| SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
| SUMIF based on 2 conditions | Excel Worksheet Functions | |||
Threaded Mode
