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.
Something like:
=SUMIF(C2:C100,">"&0,C2:C100)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Though in this instance given the values being summed are the same as those being "critiqued" the 2nd range reference isn't necessary.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks for this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks