Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel formula

Status
Not open for further replies.
rodwf

rodwf

MIS
Sep 20, 2005
85
CA
anyone know how to make a formula where a value in multipul cells are deducted from a total to leave a new total? i.e cell n1 has a value of 30 and i wish to deduct a value from cell A1 to D1 all with values of 1 and the new total is shown in O1 ?
 
Sort by date Sort by votes


Hi,

How about...
[tt]
O1: =N1-SUM(A1:D1)
[/tt]


Skip,
[glasses]Don't let the Diatribe...
talk you to death![tongue]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Upvote 0 Downvote
Hey Skip,

Excellent, that done the trick :)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
541
SkipVought
S
PSchubert
  • Locked
  • Question
Excel: Formula only works with certain numerical values
Replies
12
Views
882
dhookom
dhookom
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
633
bs6600
bs6600
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
317
TomSalvato
TomSalvato
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
369
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top