SOLVED

How do I create a formula in one sheet to + or - a number from a range of cells in another sheet?

Copper Contributor

I have a sheet (Sheet1) with a cell that has a # and I need that # to decrease or increase based on another sheet (Sheet2) range of cells.

4 Replies

@tlwarranties 

With your permission, I recommend to provide more information.

If possible, add a file (without sensitive data) and use this file to describe your issue/project step by step, or add photos with the appropriate description.

Please, always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

Don't forget that not every Excel user has a clue about every job and what you see he can't see.

 

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

@NikolinoDE  I figured that part out, thanks.  New question:  how do I stop a value from repeating when there is nothing in one of the cells i'm using in the formula?  Is there a way to make those either zeros or just blank?

 

 Untitled.png

best response confirmed by Hans Vogelaar (MVP)
PERFECT!!! thank you so much for your help!
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)