I have a simple formula just adding up a colum of cells. The problem comes in when 1 of the cells ends upp with a negative number, my total gets thrown off.
This is my formula:
=SUM(K67:K97)
I have a simple formula just adding up a colum of cells. The problem comes in when 1 of the cells ends upp with a negative number, my total gets thrown off.
This is my formula:
=SUM(K67:K97)
Try this.
=SUMIF(K67:K97,">0")
Dean
Thanks for the quick reply, it worked great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks