I entered a formula that counts the cells containing data and subtacts one from the total.
=COUNT(G7:G48)-1
Is it possible to prevent this calculation from returning a negative value? (only subtract 1 when count is > or = to 1)
I entered a formula that counts the cells containing data and subtacts one from the total.
=COUNT(G7:G48)-1
Is it possible to prevent this calculation from returning a negative value? (only subtract 1 when count is > or = to 1)
Try
=MAX(0,COUNT(G7:G48)-1)
Thanx daddylonlegs... worked great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks