Forum Discussion
Solved
How to reference to a cell but not with vlookup function or referencing by + sign
Hi, can someone help me with this issue. I will have a trial balance in one sheet of excel file. In another sheet I will have costs according to some subgroups, and in third sheet there will be pro...
How about this?
Though make sure that the account number in A are texts. And in this example I limited the data ranges to only 20 rows. You can adjust that a much larger range, though avoid referencing entire columns like A:A.
Even better to use a structured table for the data. Such a table will expand automatically when you add rows to it and you can reference ranges by the table and column name.
Riny_van_Eekelenthank you for your answer. I actually did it with sumif. I added two more columns next to each account, wrote the P&L item (income, costs....etc...) and did the whole P&L sheet and costs sheet with sumifs. Thank you for the formula ("40*"), might use this one next time.