Re: Adding up #s in Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sorry, you lost me.

The formula I provided does satisfy your 1st question (I almost certain!)

Try to be more concise in your requirements
a Column is referred to in Letters (e.g. column A - top to bottom)
a Row is referred to in Numbers (e.g. row 1 - left to right)
a Cell is referred to in Letter/Number combinations (e.g. cell A1)

************************************************************
As an example of a help request Id ask something like

I have a table consisting of ...
Name (Col A)
Hours_Absent (Col B)
Hours_Remaining (Col C)

When I enter a value in the Hours_Absent (Col B), the Hours_Remaining (Col C)should update.
Hours_Remaining should be HOURS_ALLOWED - Hours_Absent
(HOURS_ALLOWED will be a fixed value (On Sheet2 in Cell B1))

How can I achieve this?
************************************************************

Is this what you require? Let me know & I'll sort it for you

PS if this is what you require, the solution would be
* In CELL C2, enter =Sheet2!$B$1 - B2
* Copy C2 down into C3, C4, C5 etc





"EQ" <zerospam@xxxxxxxx> wrote in message news:uizp951SFHA.580@xxxxxxxxxxxxxxxxxxxxxxx
>
> Thanks... but here's what is happening. Now everytime I put something in
> the first column (lest say B1), everything changes in the whole table.
> I'm trying to create a record of employees and their absence hours. So,
> if the employee in column A1 was absent today, I put the amount of hours
> he was out in B1.
> This will cause C1 to substract from the amount of hours he's allowed to
> use in a year.
>
> If I keep that formula, then all of my employees below the one I'm
> updating, will have the same record.
>
> Can I avoid this from happening, so that only the row I'm working on
> will be the one affected by the changes?
>
> Thanks again...
>
>
> *** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Dynamic formulas
    ... I am currently trying to get a cell to recognize the amount of work completed ... by employees on a certain day, ... How would I be able to get Excel to recognize today's date, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can my company take my time without compensation?
    ... the savings made by this program during one year. ... lookup algorithm that brings up the description of a fault code (or ... themselves any favours by being mean with their employees. ...
    (uk.legal)
  • Back Pay precedence in Bankruptcy
    ... promised a bonus a few years ago in this amount and was given a letter ... It owes back pay to other employees too - totalling 800K. ... Oregon law hold or Delaware or Federal? ...
    (misc.legal)
  • Re: Worksheet Lists
    ... My mistake was referencing the B2 cell ... This works to pull the employees last name to the Last Name column, ... columns which pull data from one or more of the other worksheets. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: VLOOKUP not working with data from PeopleSoft
    ... cell is formatted as text. ... Format it as General, and re-enter your formula. ... I tried copying the data from the all employees file into a sheet in the ...
    (microsoft.public.excel.worksheet.functions)