I have a column within which only cells containing a >0 value are highlighted using colour RGB = 221, 217, 196.
I wish to sum only these cells, however any VBA I have been able to find specifies it does not work with conditional formatting. Can anyone give me a hand?
Last edited by FranAgrippina; 04-25-2013 at 08:51 AM.
Assuming your data is in cells D2:D18 for example
=SUMPRODUCT((D2:D18>0)*(D2:D18))
would only sum values which are greater than 0
Elegant Simplicity............. Not Always
Hi and welcome to the forum
Use sunif() or sumifS() based onm the same rules you used for your CF
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
My thanks to you both....and I apologize for wasting your time....I was so busy seeing the trees...I forgot about the forest....the solution was indeed a basic one...one I should have thought about .... but no....I was caught up in a much more complex train of thought!. Again thank you....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks