Forum Discussion
Which formula to use to get data from 11 sheets to trial balance
Hi, My question is how to effectively get the numbers from planning sheets (there is 11 of them, each one represents one colleague to plan) into trial balance? From trial balance to P&L I already ha...
Harun24HRthank you for exel, I checked the formula but I don't know how to correct it. I can see it takes all eleven sheets into consideration, but the value it gave is 50 - insted of : 550, how to get that?
In each sheet someone planned 50 in certain month, on certain account, I need the sum of all 11 sheets, on this account in this month. I hope you understand what I mean. I can see it is written SUM (VLOOKUP(A3;x;5;0) but it gave only 50 insted of 550.
Can you please share a sample file showing your inputs and desired output?