I have a column set to currency that includes negative values, text and positive values (yes I know that's not good). Is there any way I can write =SUM(C2:C100) and qualify it with an additional statement? Thanks.
I have a column set to currency that includes negative values, text and positive values (yes I know that's not good). Is there any way I can write =SUM(C2:C100) and qualify it with an additional statement? Thanks.
Last edited by Kochanski; 12-03-2010 at 09:15 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks