How to Use the AVI Converter: Average of a range using only the blank cells. [Solved]

Average of a range using only the blank cells.

I am using a spreadsheet to budget my income/spending.
I am using the days in my pay period and the money I have after paying bills to find the average amount of money I can spend everyday to stay within my spendable income.
In this range I am trying to
find the average spending that remains throughout the pay period for days that have not occured yet.
How do I find the average for the remaining days using the amount of money I have remaining by calcutating only the days (cells) that are blank within the
range?

Example: I have a range of 15 days (pay period) with say $500 (spending money) that I have averaged for those 15 days.
Say I am four days into that pay period and have spent $130.
I want to find the formula for finding the average amount of spending that
I have for the remaining 11 days of the pay period and the remaining $370 automatically.
How do I find a formula that will account for the money I have remaining and average it on only the remaining empty cells (remaining 11 days).

I would like this to automatically update when I insert money spent on the 5th day and so on.

I hope that this makes sense, and if anyone can give me any tips, I would appreciate it.

Anwsers to the Problem Average of a range using only the blank cells.

Download SmartPCFixer to Fix It (Free)

You have decided not to mention the columns in use but if the money is input to C2:C16 (15 days) and the
500 is in C1 then try,

=IFERROR((C1-SUM(C2:C16))/COUNTBLANK(C2:C16),0)

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Average of a range using only the blank cells. in Windows.

Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
Close the Command Prompt Window because we are done.

Try and see if you still get the same error Average of a range using only the blank cells. in your Windows.

Note: You may be prompted to enter your administrator's password when you try to execute certain system tasks!

Another Safe way to Fix the Problem: Average of a range using only the blank cells.:

How to Fix Average of a range using only the blank cells. with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Run it, and it will scan your computer. The errors will be shown in the list.