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
Hi Meyanui
Give this a try.
Sunny
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
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.myonlinetraininghub.com/excel-2007-sumif-and-sumifs-formulas-explained
Good luck.
Sunny
Sunny,
Thanks a million. I appreciate and I'm grateful
