jaingalang
New Member
- Joined
- Jun 15, 2015
- Messages
- 2
I have a spreadsheet with four years of quarterly Income Statement data for 3 different companies (48 columns across, starting from column B). Each company is grouped together (i.e. the first 16 columns is data for company X, the next 16 are for company Y, etc.). Down column A is a list of income statement accounts (i.e Revenues, Expenses, Net Income, etc.)
I'd like a formula that allows me to show the consolidated (sum) amounts for each entity across each account (i.e Total Revenues for company X, Y & Z = $X.XX MM, or total Net Income for Company X,Y,Z). I'd need to show this data for the 16 quarters.
Since the entities are across various columns, how can I ensure that the correct accounts are being summed across the correct periods using correct entities?
I get that I could possible go =SUM(Q1 Net Income Company X + Q1 Net Income Company Y + Q1 net Income Company Z) manually, but was hoping for a formula. Sumifs? Vlookup?
Thanks in advance for your help!
I'd like a formula that allows me to show the consolidated (sum) amounts for each entity across each account (i.e Total Revenues for company X, Y & Z = $X.XX MM, or total Net Income for Company X,Y,Z). I'd need to show this data for the 16 quarters.
Since the entities are across various columns, how can I ensure that the correct accounts are being summed across the correct periods using correct entities?
I get that I could possible go =SUM(Q1 Net Income Company X + Q1 Net Income Company Y + Q1 net Income Company Z) manually, but was hoping for a formula. Sumifs? Vlookup?
Thanks in advance for your help!