Sum of cell if less than zero.

[Gref]

I have a cell on one worksheet of a spreadsheet that has information from a second worksheet that is a total of a column on the second worksheet. The formula I have takes the total from the column in the second worksheet and puts it into a cell on the first worksheet.

The current formula I have in the cell of the first worksheet is this: =SUM('Bar Bingo'!E34)
Bar Bingo is the name of the second worksheet.

I want to include an "If" function that if the number in the cell on the second worksheet is less than zero it will appear as zero in the cell of the first worksheet.

 

[CokeOrCrack]

=IF(SUM('Bar Bingo'!E34)<0,0,SUM('Bar Bingo'!E34))

 

[Joe4]

You don't need to use the IF function, and the SUM function is totally unnecessary. You only use SUM on a range of cells, not a single cell.
Just use the MAX function, i.e.

=MAX([COLOR=#333333]'Bar Bingo'!E34,0)[/COLOR]

 

[Gref]

Thanks Joe4. How simple. Wish I were an Excel expert!

 

[Joe4]

You are welcome!

Wish I were an Excel expert!

Keep at it, and maybe some day you will be!