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.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Troubleshoot:Control panel program options,copy paste Chart as linked Picture [Solved],Troubleshooting:Count characters in worksheet Error,Troubleshooting:creating seperate columns in a stacked column graph Error,Solution to Problem: Copying Formulas When Cells Are Skipped,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly

No comments:

Post a Comment