Re: add cells value base on word's color

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

<patlee311@xxxxxxxxx> wrote in message
news:3e4a08c0-0d13-41fe-80ca-93c88b303d18@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Dear all,
can I add cells value base the color of the word's color.
e.g. if word color=red then sum(a1:a10).

Thanks,
Pat.


.

Relevant Pages

  • Re: A bit more help needed on an =SUMPRODUCT if possible?
    ... which is an array formula, it should be committed with Ctrl-Shift-Enter, not ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Yes, in between 3, 13, 23 are aesthetic filler fields, shaded cells etc, ...
    (microsoft.public.excel)
  • Re: =AVERAGE returning a #DIV/0! result
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Cells AB5:AB67 contain week numbers ... =AVERAGE(IF('Call Handling Data'!$AB$5:$AB$67=37,(IF(ISNUMBER('Call ...
    (microsoft.public.excel.worksheet.functions)
  • Re: A bit more help needed on an =SUMPRODUCT if possible?
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Yes, in between 3, 13, 23 are aesthetic filler fields, shaded cells etc, ... "Bob Phillips" wrote: ...
    (microsoft.public.excel)
  • Re: Help with averages revisited
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... again as an array formula ... (I did change the cells from A1:A5 to the cells I was using, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Exclude text from sums
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Your formula returns text numbers which of course SUM() to zero. ... for all text cells. ...
    (microsoft.public.excel.misc)