Computer and Software Help > In Microsoft excel I have a column from 1 to 10. I input ... >

Ask Your Computer Question. Computer Experts Answer You ASAP.

(Not a Computer Question?)

In Microsoft excel I have a column from 1 to 10. I input numbers into the columns during the Month. The amount of numbers entered vary each month.some Months there may be 8 another month 6.I need a formula that will find the last number entered and subtract it from last months total.
This is actually vehicle monthly milage where i subtract the last entry in the current month from the last entry from last month.
I need a formula something like "Find last number in column G and subtract it from last months total =sum(jun!g19)"

Optional Information:
OS: Windows XP; Browser: Firefox

Already Tried:
every think I can think of. =sum(g9,g8,g7_g3) my last number may finnish in any one of these cells

Customer (name blocked for privacy)

Status: Closed Value: $8

Hi and Welcome to Just Answer,

Ok, let's take a look at this;

Try this for your formula

=SUM(G7:G9)-G3

If you find this post helpful please take a few minutes to leave Feedback.

By you leaving Positive Feedback you give your Expert additional opportunities to earn extra CASH and Recognition.

If you would like to give a Bonus they are always welcome.

If there is anything else let me know, If not click accept. Thank You Michael L.

Thank You Very Much. If this helps, click on the"Accept." Michael L

Reply to Michael L....... JA Computer Expert's Post: That did not help. I dont want to total the column I just want the last number entered subtracted from the first number.T problem is to write a formula to look at empty spaces and take the first entry from the bottom and subtract it from the first entry.
There is always empty cells at the bottom of the column and I do not know in what cell the last entry will be.
ie   71990
     72690
     73435
     74185
     empty cell
     empty cell
     empty cell
I need a formula that looks for the last number entered, if I use =sum(c1:c7)-c1 it gives the wrong answer. I need a formula to cover the whole column.

THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.

Hello,

Michael L has asked to help out on this question.

I think what you need to use here is the MAX function which can read all the items in a column and choose the largest number (in your case it is the last number) ignoring any presence of empty cells.

It goes like this:

=MAX(C1:C50)

You can of course use this function within a formula that gets the last number from column C and subtract it from the cell in question, or however you want to use it.

I have prepared here a sample spreadsheet that would deduct the last miles of the previous month from the mileage you enter in the current month. (Start with February as there is no previous month for January).

Sample mileage worksheet

Hope this helps. Let me know if you need further assistance.

...If you found my answer helpful please click the ACCEPT button.
Positive Feedback is greatly appreciated.

THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.

Think you can answer this question?
Login or Become an Expert

DISCLAIMER: You acknowledge that any information you may obtain from individuals you contact through use of the Just Answer service comes from those individuals, not from Just Answer!, and that Just Answer is not in any way responsible for any of the information these third parties may supply. The site and services are provided "as is" with no warranty and no representations are made regarding the qualification of an Expert. Responses and comments on Just Answer! are for general information and are not intended to substitute for informed professional advice (such as medical, legal, investment or accounting) and do not establish a professional-client relationship. Just Answer! is not intended or designed to address EMERGENCY QUESTIONS which should be directed immediately by telephone or in-person to qualified professionals. Please carefully read the Terms of Service.

Just Answer! > Computer and Software Help

Related Answers