Hi, been a while since I visited, takes me back.
I have a workbook with a worksheet called Download in it, once a month I download data and paste it into this sheet.
There are then 12 sheets one for each month of the year Columns E6 downward on each sheet are Income.
Column H in each sheet is used for a unique one letter code.
At the end of the Workbook is an Income & Expenditure Sheet with all of the unique codes A - V in column A, a Description in Column B and then the Income for each month in columns C (Jan) - N (Dec).
The layout is like this -
Col Col Col
A B C
Code Description Jan
A Rent =SUMIF(Jan!$H$6:$H$150,'Income & Expenditure'!$A7,Jan!$E$6:$E$150)
B Water
C Insurance
For Jan the formula is =SUMIF(Jan!$H$6:$H$150,'Income & Expenditure'!$A7,Jan!$E$6:$E$150) so it sums all of the income for code A for example on the Jan sheet and shows it on the income and expenditure sheet in D7, Feb is in E7 and so on and coder B is in D8 for Jan and E8 for Feb etc.
Is there a way to split the sumif?
So say the income for Jan in a specific cell on the Jan Sheet was £100 and £50 should be allocated to code A and £50 to code B on the Income & Expenditure Sheet is there a workaround to split the value £100?
Many thanks for any and all assistance.
Bookmarks