Hi all,
I have two sheets that contain products and the amount sold, I'm trying to sum the total items sold for only 5 items that sold most. Trick is I want to split the 5 items to sum between two sheets, on sheet1 sum only 2 of 5 (value in D1)
<tbody>
</tbody>
then check sheet2 and sum the rest of 5 (in this case 3)
<tbody>
</tbody>
In this example the results would be, the top 5 items sold a total of 133. note that only sheet1 specifies the amount of rows to sum.
I have two sheets that contain products and the amount sold, I'm trying to sum the total items sold for only 5 items that sold most. Trick is I want to split the 5 items to sum between two sheets, on sheet1 sum only 2 of 5 (value in D1)
A | B | C | D | |
1 | # Rows Count | 2 | ||
2 | PA | 15 | ||
3 | PB | 45 | ||
4 | PC | 7 | ||
5 | PD | 12 | ||
6 | PE | 2 | ||
7 | PM | 6 | ||
8 | PN | 18 |
<tbody>
</tbody>
then check sheet2 and sum the rest of 5 (in this case 3)
A | B | |
1 | PF | 21 |
2 | PG | 5 |
3 | PH | 9 |
4 | PI | 16 |
5 | PJ | 8 |
6 | PK | 33 |
7 | PL | 2 |
<tbody>
</tbody>
In this example the results would be, the top 5 items sold a total of 133. note that only sheet1 specifies the amount of rows to sum.