Hi
i've tried searching a bit but i'm still new with SUMPRODUCT and not sure how to find a solution to this.
Attached is a workbook showing what i'm trying to achieve.
I am currently using VLOOKUP to pull info from an EXTERNAL workbook. 5 account numbers are listed on separate lines, one vlookup for each line, and the result is summed to give a total.
At this stage, I am only able to write the sumproduct on individual lines to achieve the same effect as a sumif. I could combine these formulas into one long sumproduct but that would be quite tedious.
I want to know if there is a simple SUMPRODUCT formula that can be written where i simply specify the full list of accounts, data to be summed, and then highlight all required accounts at once.
i am reluctant to write out one very long sumproduct formula specifying each account number individually. My main aim is to specify the account numbers in combination (see red highlight in the attachment), and to have the answer in one cell.
Thanks in advance!
In the workbook
External sheet - column A account number, column D is the value i want to pull
Lookup - column A account number
Bookmarks