Issue = Problem with Data on Spreadsheet and calculations thereof

[aeonexcel]

Ok so I'm doing data calculations for Data in GB on a Drive
This is not my issue that's driving me nuts
WHAT IS however is trying to calculate
=IF(E16="","",E16/$F$4)
a Formula as such BUT from Range A:Range Z whereas you also have Absolute Value $F$4 where you need to have the difference of Range A:Range Z calculated as a result into Cell G4
How on earth do you do this? I don't care how it's accomplished where if it's Excel Formulae only or with VBA or Access just SOMETHING to Solve this
HELP!

[DGagnon]

could you attach a workbook with desired output? not really sure what you are getting at here.

[aeonexcel]

example.jpg
This, there's a Cell beside Backup where the result of the difference of Say $L$4-$L$6 would be
So what I'm asking is how do you get that Cell to report that difference? But the difference is variable based upon the cell in the list so everytime an entry is made it will update that Cell beside Backup with the new total

[royUK]

We need an example workbook not a screenshot

[aeonexcel]

Example Workbook file

[DGagnon]

i still dont get it... what exactly are you trying to calculate?

[aeonexcel]

Ok let's take for instance Cell B24 which is 70.04 the Max size of the Drive in question is 78.8
78.8 - 70.04 = 8.76
I want the 8.76 to be displayed in Cell C1 as a percentage ala %Left
How
Do you
Do this? I am hopelessly confused

[DGagnon]

you could do it like this,

="%"&TEXT(B24-$B$2,"0.00")

but that would not be a % it would be a value.. im assuming you want it displayed as a % for another purpose.

[aeonexcel]

Well it'll be a percentage at any rate but the daunting task I keep slamming my head into is the fact of how to get it to put the value remotely into cell C1

[DGagnon]

ok, now i get what you are trying to do.. i was looking to the wrong spot

try this array formula confirm with Ctrl+Shift+Enter

=INDIRECT("C"&MAX(IF((C3:C16<>"")*(C3:C16<>-1),ROW(C3:C16))))

you will need to adjust the range C3:C16 to match your range, i cannot open your workbook, so i do not have your ranges

[protonLeah]

aeonexcel, in the future, please post your workbooks directly to the forum and not to external file sharing sites.

Post a WORKBOOK. ... To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

Do not zip the workbook unless it is over 1 MB (which need never happen).