Sound Card Driver Updating: Fast Solution to Error: Creating a budget in Excel

Friday, September 23, 2016

Fast Solution to Error: Creating a budget in Excel

Creating a budget in Excel

Original Title: excel
i make three sheet one is only 12months budget create and second is 1st column this month budget & 2nd column actual amount i spend &third tansaction sheet this is yearly budget can we help this formula i want that wats the formula for e.g i feed data
of jan & category is salary my salary budget is 25000 & my actual amount is 20000 on write in transaction sheet & wats the that this actual month salary directly in second sheet

Solutions to the Problem Creating a budget in Excel

Download SmartPCFixer to Fix It (Free)

Examples of the data on all 3 sheets would help us provide an answer for you.
I think that you may need to use the SUMIF() and/or SUMIFS() worksheet function to solve your problem.

Formulas should all be on one line in your workbook, like this:
=SUMIF(A$2:A$7,B10,C$2:C$7)
NOT like they may be shown here as
=SUMIF
(A$2:A$7,B10,C$2:C$7)

SUMIF() Example:

CATEGORY
BUDGET
ACTUAL

Salary
25000
10000

Mortgage
1000
1000

Food
800
650

Fuel
200
120

Clothing
100
0

Salary
25000
10200

CATEGORY TOTALS:

Formulas

Salary
20200
=SUMIF(A$2:A$7,B10,C$2:C$7)

Mortgage
1000
=SUMIF(A$2:A$7,B11,C$2:C$7)

Food
650
=SUMIF(A$2:A$7,B12,C$2:C$7)

Fuel
120
=SUMIF(A$2:A$7,B13,C$2:C$7)

Clothing
0
=SUMIF(A$2:A$7,B14,C$2:C$7)

Example of SUMIFS()

Month
CATEGORY
BUDGET
ACTUAL

JAN
Salary
25000
20200

JAN
Mortgage
1000
1000

JAN
Food
800
650

JAN
Fuel
200
120

JAN
Clothing
100
0

FEB
Salary
25000
22300

FEB
Mortgage
1000
1000

FEB
Food
800
925

FEB
Fuel
200
185

FEB
Clothing
100
75

Subtotal for 1 month:

formula for Jan/Salary:

=SUMIFS(D$2:D$11,A$2:A$11,A16,B$2:B$11,B16)

JAN
Salary
20200

JAN
Food
650

Note: It is recommended that you back up your files and folders before attempting this step:

Move the mouse cursor over to the upper right side of the screen.
A menu will pop up on the left. Click on the "Settings" feature on the menu.
On the Settings window, click on the "Change PC settings."
Now, left click on the "Update and recovery" feature.
For the next step, left click on the "Recovery" feature.
There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
Now, follow the instructions on the screen to finish the Refresh process.
After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
Check again to see if the error Creating a budget in Excel has been fixed.

If you do not possess the technical expertise required to accomplish this yourself or do not feel comfortable doing so, download and install a powerful automated tool to get the job done.

Another Safe way to Fix the Problem: Creating a budget in Excel:

How to Fix Creating a budget in Excel with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system. Open it, and it will perform a scan for your system. The errors will be shown in the scan result.