A question about different column values

[snkhokhar]

I want to calculate each day value, subtract from my total value.

i.e. there are five columns( Mon, Tue, Wed Thu, Fri) and there is one
column (Total) in which is the total value.

I want, when I enter a value in Mon column, it subtract from Total
value column.
Next day when I enter a value in Tue column, again it subtract from
Total value column.

and so on......

The format of my columns is:

Total Mon Tue Wed Thu Fri
25 2

when I enter any value in any day, it subtract automatically value from
Total value columns.


I'll be very thanks.


Shahid Nawaz

 

[Bob Phillips]

In the total cell just use

=100-SUM(A2:E2)

where 100 is the start value, A2:E2 are the input cells

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)