manojxls
New Member
- Joined
- Dec 21, 2017
- Messages
- 24
- Office Version
- 365
- 2007
- 2003 or older
- Platform
- Windows
A | B | C | D | |
1 | bill no | rate | amount | required sum |
2 | 100 | 12 | 300 | |
3 | 100 | 12 | 245 | |
4 | 100 | 5 | 334 | |
5 | 103 | 12 | 456 | |
6 | 103 | 5 | 166 | |
7 | 105 | 5 | 321 | |
8 | 105 | 5 | 766 | |
9 | 105 | 12 | 776 | |
10 | 105 | 12 | 978 |
<colgroup><col span="4"><col></colgroup><tbody>
</tbody>
<colgroup><col span="3"><col></colgroup><tbody></tbody>
I want the required sum =SUMIF(A2:A10,A2 andb2,C2:C10) condition which check the bill and rate wise sum like result on d2 will 545 , d3 will 545, d4 will be 334.
i have a large data but want formula to solve.