November 9, 2016
Hi there,
I'd want formulae that will read the codes of Table A and sum them up automatically to their corresponding Amounts in Table B. That is I6 (for amount in Table B) should be the sum of all 900s in Table A , etc
VIP
Trusted Members
June 25, 2016
November 9, 2016
Sunny,
Thank you very much for the Useful answer. It's exactly that which I needed. One more thing, could you kindly explain the formula. It'll do more if i understand what is happening rather than posting little issues which i can sort out. Thanks for your response
Kind regards
VIP
Trusted Members
June 25, 2016
Hi Meyanui
What the formula SUMIFS($D$4:$D$29,$C$4:$C$29,G6) does is to sum the range D4:D29 when the range C4:C29 meets the criteria in cell G6 etc.
You can read more about SUMIFS here.
https://www.myonlinetraininghu.....-explained
Good luck.
Sunny
1 Guest(s)