sumproduct and colored cell as a condition to be met
 

can a colored cell be used as a condition for an argument? If so, how is it
written in the formula?

thanks,
George P.

sumproduct and colored cell as a condition to be met
 

Well, colored cells can be used as conditions in macros, but not in built-in
Excel functions. See, for example, here, for how to sum and count by cell
color: http://www.ozgrid.com/VBA/Sum.htm

Dave
--
Brevity is the soul of wit.


"George P" wrote:

can a colored cell be used as a condition for an argument? If so, how is it
written in the formula?

thanks,
George P.

sumproduct and colored cell as a condition to be met
 

See http://xldynamic.com/source/xld.SUMPRODUCT.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"George P" wrote in message
...
can a colored cell be used as a condition for an argument? If so, how is
it
written in the formula?

thanks,
George P.