Summing up columns by Name

We do need a workbook. Create a dummy version of the real one using dummy data that reflects the real scenario as closely as possible.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

I think that this formula yields the expected result for Desired Outcome B2:

Formula:

Please Login or Register  to view this content.

I don't understand the rest. My suggestion would be to upload a very small portion of the Desired Source spreadsheet, say 5 rows , then manually input the values that you expect to see in the Desired Outcome spreadsheet based on those five rows and the serial number entered. Once we have formulas for the small portion we should be able to adapt those formulas for the whole spreadsheet.
Let us know if you have nay questions.

Here are the formulas that fill in the table:
For Model: =VLOOKUP(A2,'Desired Source'!B$2:H$2514,7)
For Yield: =VLOOKUP($B2,'Model Lookup'!$A$2:$C$33,COLUMN(B:B)) * Pasted into D2 then dragged into C2 and down.
For Usage March to May: =SUMPRODUCT(('Desired Source'!$B$2:$B$2514=$A2)*(('Desired Source'!I$2:I$2514)+('Desired Source'!K$2:K$2514)+('Desired Source'!M$2:M$2514))) *Pasted into F2 then dragged into G2
For Usage March to August: =F2+SUMPRODUCT(('Desired Source'!$B$2:$B$2514=$A3)*(('Desired Source'!O$2:O$2514)+('Desired Source'!Q$2:Q$2514)+('Desired Source'!S$2:S$2514))) *Pasted into F3 then dragged into G3
For Usage March to November: =F3+SUMPRODUCT(('Desired Source'!$B$2:$B$2514=$A4)*(('Desired Source'!U$2:U$2514)+('Desired Source'!W$2:W$2514)+('Desired Source'!Y$2:Y$2514))) *Pasted into F4 then dragged into G4
Note: you uploaded as an .xls file although your profile says that you use the 2013 version of Excel. I am returning it to you as an .xlsx file, which is the normal file extension for your version.
Note: see further explanation on the Desired Outcome sheet cells B8:B9
Let us know if you have any questions.