How about =ABS(SUMPRODUCT(SIGN(C2:C367)))
How about =ABS(SUMPRODUCT(SIGN(C2:C367)))
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thanks all for your reply.
I am combining this code with another code in VBA and it would have been nice to have everything in vba.
I have tried some of your suggestion but they seem to be giving something else.
i may have expressed myself incorrectly, but what i meant was to count the rainy days, not the amount of rain in each cell.
Malowle
Last edited by Malowle; 08-02-2012 at 05:34 PM. Reason: No reason
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks