Excel Formula

[Josue0]

Hello everyone!

So I was working on a formula for a project budget in excel, and I can't get it to work. Here's where I need help!

I have a two Budget Summary (spreadsheet1=Year 1 and spreadsheet2 = year 2) each sheet has different Categories (columns) Salaries A1, Travel A2, and Equipment A3. So a ChangeLog spreadsheet was created to manage the reallocation from differnt categories. The changelog then has two columns showing the from and to where to amount is being allocated.

For example: In the changelong sheet, i would enter year 1, $500 from Salaries to Travel, then the forumla i want should pickup the current budget in the spreadsheet year 1, deduct from Salaries $500, give me the new amount, and also add the $500 to the current budget in Travel.

Can anyone help? My current formula is as follows but it changes the amounts in all spreadsheet.

=IF(INDEX('Change Log'!B:B,MATCH(TRUE,'Change Log'!B:B=1,0)),D12-(SUMIFS('Change Log'!F:F,'Change Log'!D:D,'Financial Summary Report 1 '!A12))+SUMIFS('Change Log'!F:F,'Change Log'!E:E,'Financial Summary Report 1 '!A12),D12)

 

[Joe4]

Duplicate to: Formula to change values in different cells - HELP!!

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.