jjramirez85
New Member
- Joined
- May 21, 2014
- Messages
- 19
Hi, I have a summary table similar to the one below. The worksheet has column headers with multiple criteria consolidating into the single row criteria.
<tbody>
</tbody>
The data is located in something such as the example below and includes all months for both FCST and Actual.
<tbody>
</tbody>
What formula is best to be used in this situation? I have tried hlookup, concantenate, and sumifs. I cant seem to get it right. I had it solved in the past, but cant seem to remember.
In general, I am wanting to summarize the account data by consolidating the accounts based on the matching headers,
FCST | Actual | |
October | October | |
2017 | 2017 | |
Account 1 | ||
Account 2 | ||
Account 3 | ||
Account 4 |
<tbody>
</tbody>
The data is located in something such as the example below and includes all months for both FCST and Actual.
FCST | FCST | Actual | Actual | |
October | November | October | November | |
2017 | 2017 | 2017 | 2017 | |
Account 1 | 62 | 21 | 10 | 68 |
Account 1 | 35 | 32 | 62 | 65 |
Account 1 | 32 | 12 | 28 | 38 |
Account 2 | 94 | 24 | 63 | 54 |
Account 2 | 82 | 35 | 92 | 65 |
Account 2 | 82 | 95 | 45 | 57 |
Account 3 | ||||
Account 3 | ||||
Account 3 | ||||
Account 4 | ||||
Account 4 | ||||
Account 4 |
<tbody>
</tbody>
What formula is best to be used in this situation? I have tried hlookup, concantenate, and sumifs. I cant seem to get it right. I had it solved in the past, but cant seem to remember.
In general, I am wanting to summarize the account data by consolidating the accounts based on the matching headers,