Hi Manoj,
I already suggested you the way which is possible using formula. I have a sound
grip on formulas and didn't know one which let you handle the cell color. So
the alternative is on Coding side which you already have.
BTW how you color cells. Is there any condtion for that (no matter if you
aren't using that at this time) ? If yes then you may get you answer using
formula.
Thanks & Regards
Sandeep
----- Original Message -----
From: Manoj S Negi
To: excel-macros@googlegroups.com
Sent: Friday, November 20, 2009 8:36 PM
Subject: Re: $$Excel-Macros$$ How to sum on the basis of color
Hi Sandeep,
Thanks for your consideration on this but i was looking for some kind of
formula so that whenever any coloured cell get any value, the sum formula get
update automatically.
Unfeigned Regards
Manoj S Negi
Skype - manojsnegi
On Fri, Nov 20, 2009 at 7:52 PM, Sandeep Kumar Maurya <sandymau...@gmail.com>
wrote:
Hi,
You can filter on the basis of color in excel 2007. And with that you can
use subtotal(9,Range) for your data.
Subtotal don't sum those value which are hidden.
Thus you can get sum on the basis of color in excel 2007 using filter and
subtotal.
But if you want to see both value at time then it is not possible using
this method. There are many experienced person in the group who may help you
out.
Regards
Sandeep
On Fri, Nov 20, 2009 at 5:30 PM, Dave Bonallack <davebonall...@hotmail.com>
wrote:
Hi Manoj,
I've looked at XL2007, but it appears I was mis-informed. I see no
built-in function for summing by colour. Sorry.
Regards - Dave.
--------------------------------------------------------------------------
Date: Thu, 19 Nov 2009 13:40:27 +0530
Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
From: manojsnegi.uttranc...@gmail.com
To: excel-macros@googlegroups.com
Thank you very much Dave.
Can you suggest some clue how to do the same think in excel 2007 without
macro.
Unfeigned Regards
Manoj S Negi
Skype - manojsnegi
---------- Forwarded message ----------
From: Dave Bonallack <davebonall...@hotmail.com>
Date: Thu, Nov 19, 2009 at 1:12 PM
Subject: RE: $$Excel-Macros$$ How to sum on the basis of color
To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>
Hi,
The attached uses a macro to do your bidding. But I think XL2007 can do
this without macros, but I only have XL2003.
Regards - Dave
--------------------------------------------------------------------------
Date: Thu, 19 Nov 2009 12:45:00 +0530
Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
From: manojsnegi.uttranc...@gmail.com
To: excel-macros@googlegroups.com
Hi All,
please help on this........................................
Unfeigned Regards
Manoj S Negi
Skype - manojsnegi
---------- Forwarded message ----------
From: Manoj S Negi <manojsnegi.uttranc...@gmail.com>
Date: Wed, Nov 18, 2009 at 12:56 PM
Subject: $$Excel-Macros$$ How to sum on the basis of color
To: excel-macros@googlegroups.com
Hi All,
Kindly help me out as I want to sum the no. as per the color. Is there
any command by which we can sum the data as per color.
Sheet is also attached for further reference.
Hoping for a favorable response soon.....
Unfeigned Regards
Manoj S Negi
Skype - manojsnegi
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes
about the learning and support from the group. Our goal is to have 10,000
subscribers by the end of 2009. Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes
about the learning and support from the group. Our goal is to have 10,000
subscribers by the end of 2009. Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--------------------------------------------------------------------------
Brought to you exclusively by Windows Live Download new and classic
emoticon packs at Emoticon World
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes
about the learning and support from the group. Our goal is to have 10,000
subscribers by the end of 2009. Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes
about the learning and support from the group. Our goal is to have 10,000
subscribers by the end of 2009. Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--------------------------------------------------------------------------
Brought to you exclusively by Windows Live Download new and classic
emoticon packs at Emoticon World
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes
about the learning and support from the group. Our goal is to have 10,000
subscribers by the end of 2009. Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about
the learning and support from the group. Our goal is to have 10,000 subscribers
by the end of 2009. Let friends and co-workers know they can subscribe to group
at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about
the learning and support from the group. Our goal is to have 10,000 subscribers
by the end of 2009. Let friends and co-workers know they can subscribe to group
at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
