SUMIF function with text color condition

I am creating a simple addition formula but I want my formula to only count
numbers in corresponding row from text in the color blue(or red, green,
etc.). Help would be much appreciatted.

Visit Chip Pearson's site for working with colored cells.

http://www.cpearson.com/excel/colors.htm

See the SumByColor Function.


Gord Dibben MS Excel MVP


On Thu, 17 Aug 2006 18:43:02 -0700, MrWallyWorld
<[email protected]> wrote:

>I am creating a simple addition formula but I want my formula to only count
>numbers in corresponding row from text in the color blue(or red, green,
>etc.). Help would be much appreciatted.
>

There's nothing built into excel that allows you to do this.

If you want a macro, you could use Chip Pearson's:
http://cpearson.com/excel/colors.htm

MrWallyWorld wrote:
>
> I am creating a simple addition formula but I want my formula to only count
> numbers in corresponding row from text in the color blue(or red, green,
> etc.). Help would be much appreciatted.

--

Dave Peterson

Both or at least one of us is redundant<g>


Gord

On Thu, 17 Aug 2006 21:13:45 -0500, Dave Peterson <[email protected]>
wrote:

>There's nothing built into excel that allows you to do this.
>
>If you want a macro, you could use Chip Pearson's:
>http://cpearson.com/excel/colors.htm
>
>MrWallyWorld wrote:
>>
>> I am creating a simple addition formula but I want my formula to only count
>> numbers in corresponding row from text in the color blue(or red, green,
>> etc.). Help would be much appreciatted.

From the Department of Redundancy Department?



Gord Dibben wrote:
>
> Both or at least one of us is redundant<g>
>
> Gord
>
> On Thu, 17 Aug 2006 21:13:45 -0500, Dave Peterson <[email protected]>
> wrote:
>
> >There's nothing built into excel that allows you to do this.
> >
> >If you want a macro, you could use Chip Pearson's:
> >http://cpearson.com/excel/colors.htm
> >
> >MrWallyWorld wrote:
> >>
> >> I am creating a simple addition formula but I want my formula to only count
> >> numbers in corresponding row from text in the color blue(or red, green,
> >> etc.). Help would be much appreciatted.

--

Dave Peterson