IF statement across multiple sheets

[marahchristine]

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.

[mikeTRON]

Please Login or Register  to view this content.

[Tony Valko]

Maybe this...

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

[mikeTRON]

Maybe this...

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

Oh, why didn't I think of that?

[Tony Valko]

Oh, why didn't I think of that?

You just did!

[marahchristine]

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!

[marahchristine]

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!

[marahchristine]

=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).

[Tony Valko]

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