Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count by Colour (Text) with other criteria
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count by Colour (Text) with other criteria
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
how do I 'count' the number of cells with a text in red or black? | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |