i want sum with coloured rows or columns and I am using MS Office 2007
i want sum with coloured rows or columns and I am using MS Office 2007
Without macro:
- Create filter in first row
- Filter by color
- Add SUBTOTAL(109, your_range) formula above
thanks
but i want display all values and total the coloured rows or columns
You'll need to use VBA for that. Here are 4 UDFs that enable you to count and sum cells by colour, or to count and sum cells by font colour. Enable macros on opening.
The code you need to copy is in module 1.
Last edited by Glenn Kennedy; 12-05-2015 at 05:49 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
thanks sir i am trying to do this
hai
I am attaching a file containing date and qty.
I want CONDITIONAL FORMATING (Dec 2015 & Jan 2015 ) with Qty coloured.
With out VBA code if possible.
Last edited by naaagu; 12-07-2015 at 02:20 AM. Reason: new post
If this is a new question please open a new thread.
Last edited by zbor; 12-07-2015 at 05:09 AM.
Have you been able to use the solution that I suggested?
thank q sir i tried it
...and did it work for you or not? Do you need any further help in getting it to work?
Getting some feedback is very helpful for us and for others who may have the same problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks