Register
Log In
Unanswered
Home
November 9, 2016
Offline
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
See Answer
Dashboards
June 25, 2016
Offline
Hi Meyanui
Give this a try.
Sunny
Answers Post
November 9, 2016
Offline
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
Dashboards
June 25, 2016
Offline
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
Most Users Ever Online: 57
Currently Online:
25 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
