Count by Colour (Text) with other criteria

[Paul Sheppard]

I have a range of data in cells G4:O181

I have used =COUNTIF($G$4:$O$181,"Debs") to count the number of occurences of Debs

In some of the cells Debs is black text and some Debs is red text

=(PERSONAL.XLS!CountByColor(G4:O181,3,TRUE)) will give me the total number of cells that have Red Text

I have tried this formula to calculate the number of cells that are both Debs and red text =SUM(G4:O181="Debs")*((PERSONAL.XLS!CountByColor(G 4:O181,3,TRUE))), enterred as an array, but get the value zero

How can I combine the two to get the result for the number of cells in the range that are Debs and red text

Thanks in advance for any help
__________________
Hope this helps

Paul

[Dave Peterson]

You have another reply at your other thread.

Paul Sheppard wrote:
>
> I have a range of data in cells G4:O181
>
> I have used =COUNTIF($G$4:$O$181,"Debs") to count the number of
> occurences of Debs
>
> In some of the cells Debs is black text and some Debs is red text
>
> =(PERSONAL.XLS!CountByColor(G4:O181,3,TRUE)) will give me the total
> number of cells that have Red Text
>
> I have tried this formula to calculate the number of cells that are
> both Debs and red text
> =SUM(G4:O181="Debs")*((PERSONAL.XLS!CountByColor(G 4:O181,3,TRUE))),
> enterred as an array, but get the value zero
>
> How can I combine the two to get the result for the number of cells in
> the range that are Debs and red text
>
> Thanks in advance for any help
> __________________
> Hope this helps
>
> Paul
>
> --
> Paul Sheppard
>
> ------------------------------------------------------------------------
> Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
> View this thread: http://www.excelforum.com/showthread...hreadid=502460

--

Dave Peterson