Thread: sumproduct and colored cell as a condition to be met
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default 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.
Reply With QuoteReply With Quote