# IF statement across multiple sheets

1. ## IF statement across multiple sheets

This is my formula. =IF(Start!I7:End!I7>0, 0, Start!I7:End!I7) I get the error #value!

I have a worksheet called Start at the beginning and a worksheet called End at the end of the sheets.

On my sheet in the middle, I want a cell to add up all of the I7 values from Start to End and if it is greater than 0 to display 0. If not, I want it to display the sum of all of the I7 values.

This formula works if I do =IF(Start!I7-End!I7>0, 0, Start!I7-End!I7) with the subtraction.

2. ## Re: IF statement across multiple sheets

``Please Login or Register  to view this content.``

3. ## Re: IF statement across multiple sheets

Maybe this...

=MIN(0,SUM(Start:End!I7))

4. ## Re: IF statement across multiple sheets

Originally Posted by Tony Valko
Maybe this...

=MIN(0,SUM(Start:End!I7))
Oh, why didn't I think of that?

5. ## Re: IF statement across multiple sheets

Originally Posted by mikeTRON
Oh, why didn't I think of that?
You just did!

6. ## Re: IF statement across multiple sheets

This is what I am going to use:

=IF(MIN(START:END!I7)>0, 0, MIN(START:END!I7))

I want it to subtract all of the sheets. I didn't know =MIN existed! Thanks everyone!

7. ## Re: IF statement across multiple sheets

This is what I am going to use:

=IF(MIN(START:END!I7)>0, 0, MIN(START:END!I7))

I want it to subtract all of the sheets. I didn't know =MIN existed! Thanks everyone!

8. ## Re: IF statement across multiple sheets

=IF(MIN(START:END!I7)>0, 0, MIN(START:END!I7))

Doesn't give me the right answer. Telling me 0.

I have 4 sheets where I7 is: 0, -149, 55, 0. The answer should be -204 (-149-55). The cells are empty in START and END sheets.

=MIN does not mean minus. I don't want the minimum. I want it to subtract all the I7 cells from each other.

=IF(SUM(START:END!I7)>0, 0, SUM(START:END!I7))
This works if I make my cells all negative numbers (i.e. -55).

9. ## Re: IF statement across multiple sheets

Originally Posted by marahchristine

I have 4 sheets where I7 is: 0, -149, 55, 0. The answer should be -204 (-149-55). The cells are empty in START and END sheets.

=MIN does not mean minus. I don't want the minimum. I want it to subtract all the I7 cells from each other.
Then you would have to do something like this...

=Sheet1!I7-Sheet2!I7-Sheet3!I7-Sheet4!I7

There are currently 1 users browsing this thread. (0 members and 1 guests)