LinkBack URL
About LinkBacks
Attached is a simplified example of what I'm trying to do. I'm trying to sum all the Amounts in TABLE B that match the Account #'s in TABLE A that match the Descriptions in TABLE C. The formulas will go in cells C3:C4.
I'm stumped. Any help?
Attached is a simplified example of what I'm trying to do. I'm trying to sum all the Amounts in TABLE B that match the Account #'s in TABLE A that match the Descriptions in TABLE C. The formulas will go in cells C3:C4.
I'm stumped. Any help?
C3
C4
Please Login or Register to view this content.
For either C3 or C4 formula confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula.Please Login or Register to view this content.
Last edited by Ali Kırksekiz; 03-25-2015 at 04:45 AM.
Thank you for that. May I throw a curve ball? Attached is the same problem but this time I need to
sum the amounts in TABLE B where the left 6 dimension characters match the account #'s in TABLE A which match the description in TABLE C.
Thanks a million.
Last edited by buckobro; 03-25-2015 at 02:09 PM.
For C3 cell
For C4 cellPlease Login or Register to view this content.
If you want ,You can write CASH instead of B3 ( likewise B4 or PRODUCT SALES)Please Login or Register to view this content.
This in an array formula and so must be confirmed with CTRL+SHIFT+ENTER and not just ENTER.
Hi this is non array function just for information copy in c3 and drage it down
Formula:
Please Login or Register to view this content.
Punnam
Is Table A and Table B always in the same dimension (size) and
Each item will appear only one time in the tables?
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks