A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

sumif function



 
 
Thread Tools Display Modes
  #1  
Old September 15th, 2003, 10:54 AM
Dee
external usenet poster
 
Posts: n/a
Default sumif function

I am trying to use sumif function to add up a range in
excel using color as "CRITERIA". Is this possible? or is
there another way to go about it? Thanks.
  #2  
Old September 15th, 2003, 11:02 AM
Chip Pearson
external usenet poster
 
Posts: n/a
Default sumif function

Dee,

You have to use a VBA function to read the ColorIndex value of a cell. See
the "Counting Cells With A Specific Color" section at
www.cpearson.com/excel/colors.htm for more details and example code.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Dee" wrote in message
...
I am trying to use sumif function to add up a range in
excel using color as "CRITERIA". Is this possible? or is
there another way to go about it? Thanks.



  #3  
Old September 15th, 2003, 11:06 AM
Chip Pearson
external usenet poster
 
Posts: n/a
Default sumif function

the "Counting Cells With A Specific Color" section at

That should be the "Summing The Values Cells With A Specific Color", at
www.cpearson.com/excel/colors.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Chip Pearson" wrote in message
...
Dee,

You have to use a VBA function to read the ColorIndex value of a cell. See
the "Counting Cells With A Specific Color" section at
www.cpearson.com/excel/colors.htm for more details and example code.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Dee" wrote in message
...
I am trying to use sumif function to add up a range in
excel using color as "CRITERIA". Is this possible? or is
there another way to go about it? Thanks.





  #4  
Old September 15th, 2003, 11:52 AM
JMay
external usenet poster
 
Posts: n/a
Default sumif function

In your example where you start the loop:
For Each Rng In InRange.Cells

What is "InRange"?
It is not declared (Dimed)..
I can't find it in Object Browser,,
This is probably elementary, but
any comments appreciated
TIA

"Chip Pearson" wrote in message
...
the "Counting Cells With A Specific Color" section at


That should be the "Summing The Values Cells With A Specific Color", at
www.cpearson.com/excel/colors.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Chip Pearson" wrote in message
...
Dee,

You have to use a VBA function to read the ColorIndex value of a cell.

See
the "Counting Cells With A Specific Color" section at
www.cpearson.com/excel/colors.htm for more details and example code.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Dee" wrote in message
...
I am trying to use sumif function to add up a range in
excel using color as "CRITERIA". Is this possible? or is
there another way to go about it? Thanks.







  #5  
Old September 15th, 2003, 01:07 PM
Bob Phillips
external usenet poster
 
Posts: n/a
Default sumif function

It is passed to the function as an argument, and is declared in the Function
definition. It's similar to say
=SUM(A1:A100) in a worksheet function, the A1:A100 is an argument to the SUM
function.

--

HTH

Bob Phillips

"JMay" wrote in message
news:XZg9b.14214$pe.2638@lakeread06...
In your example where you start the loop:
For Each Rng In InRange.Cells

What is "InRange"?
It is not declared (Dimed)..
I can't find it in Object Browser,,
This is probably elementary, but
any comments appreciated
TIA

"Chip Pearson" wrote in message
...
the "Counting Cells With A Specific Color" section at


That should be the "Summing The Values Cells With A Specific Color", at
www.cpearson.com/excel/colors.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Chip Pearson" wrote in message
...
Dee,

You have to use a VBA function to read the ColorIndex value of a cell.

See
the "Counting Cells With A Specific Color" section at
www.cpearson.com/excel/colors.htm for more details and example code.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Dee" wrote in message
...
I am trying to use sumif function to add up a range in
excel using color as "CRITERIA". Is this possible? or is
there another way to go about it? Thanks.








  #6  
Old September 15th, 2003, 01:24 PM
JMay
external usenet poster
 
Posts: n/a
Default sumif function

Appreciate the Help Bob
I now better understand...

"Bob Phillips" wrote in message
...
It is passed to the function as an argument, and is declared in the

Function
definition. It's similar to say
=SUM(A1:A100) in a worksheet function, the A1:A100 is an argument to the

SUM
function.

--

HTH

Bob Phillips

"JMay" wrote in message
news:XZg9b.14214$pe.2638@lakeread06...
In your example where you start the loop:
For Each Rng In InRange.Cells

What is "InRange"?
It is not declared (Dimed)..
I can't find it in Object Browser,,
This is probably elementary, but
any comments appreciated
TIA

"Chip Pearson" wrote in message
...
the "Counting Cells With A Specific Color" section at

That should be the "Summing The Values Cells With A Specific Color",

at
www.cpearson.com/excel/colors.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Chip Pearson" wrote in message
...
Dee,

You have to use a VBA function to read the ColorIndex value of a

cell.
See
the "Counting Cells With A Specific Color" section at
www.cpearson.com/excel/colors.htm for more details and example code.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Dee" wrote in message
...
I am trying to use sumif function to add up a range in
excel using color as "CRITERIA". Is this possible? or is
there another way to go about it? Thanks.










 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.