masud8956
Board Regular
- Joined
- Oct 22, 2016
- Messages
- 163
- Office Version
- 2016
- 2011
- 2007
- Platform
- Windows
Hi all,
I am having some trouble summing up some data from the dynamic range B2:C15. All the fruit names that populate $B$2:$B$15 belong to to either of the 4 groups. These 4 groups are also dynamic lists.
They are:
Group1: Range $E$3:$E$15,
Group2: Range $F$3:$F$15,
Group3: Range $G$3:$G$15 and
Group4: Range $H$3:$H$15,
<tbody>
</tbody>
I want to sum up the values from B2:C15 in the following style:
Column C should show types of fruit and Column D should sum up the prices group wise.
<tbody>
</tbody>
Can anyone please help with a suitable Formula?
Thanks in advance!
I am having some trouble summing up some data from the dynamic range B2:C15. All the fruit names that populate $B$2:$B$15 belong to to either of the 4 groups. These 4 groups are also dynamic lists.
They are:
Group1: Range $E$3:$E$15,
Group2: Range $F$3:$F$15,
Group3: Range $G$3:$G$15 and
Group4: Range $H$3:$H$15,
A1 | B1 | C1 | D1 | E1 | F1 | G1 | H1 |
A2 | FRUIT | PRICE | GROUP1 | GROUP2 | GROUP3 | GROUP4 | |
A3 | Apple | 50 | Apple | Banana | Grape | Date | |
A4 | Lemon | 60 | Orange | Mango | Peach | Lemon | |
A5 | Cherry | 70 | Avocado | ||||
A6 | Coconut | 80 | Cherry | ||||
A7 | Coconut | ||||||
A8 | |||||||
A9 | |||||||
A10 | |||||||
A11 | |||||||
A12 | |||||||
A13 | |||||||
A14 | |||||||
A15 |
<tbody>
</tbody>
I want to sum up the values from B2:C15 in the following style:
Column C should show types of fruit and Column D should sum up the prices group wise.
A15 | B15 | C15 | D15 |
A16 | GROUP | FRUIT | PRICE |
A17 | GROUP1 | Apple | 50 |
A18 | GROUP2 | - | - |
A19 | GROUP3 | Cherry, Coconut | 150 |
A20 | GROUP4 | Lemon | 60 |
<tbody>
</tbody>
Can anyone please help with a suitable Formula?
Thanks in advance!