Count red numbers only in row

[stkin]

I did conditional formatting to get numbers in a cell that have the lowest value show in red. How can I count how many cells have red numbers in a row?

Example

4 5 6 4 3 2 5 4 in this example the result is 2 cells have red numbers this is what I'm trying to count.

thanks

 

[stkin]

I start at C7 thru T7 across with total for row in in V7, then I go down in the same setup thru roll 106 with total in row 107 for each column. If I could upload my file I would. Again the total for each column works but it doesn't work adding across on each row.

Example
TOTAL
C D E F G H I J K L M N O P Q R S T V
4 4 3 3 4 4 4 4 5 5 4 2 2 2 3 5 4 3 3
In this example I have 3 red numbers and that is what I'm trying to total, and I would like to do this on all rows.

Sorry I can't get it to line up, v is my total column and it should be 3

Thanks

 

[Marcelo Branco]

Please, provide an example with at least 3 rows on each column.
We need more rows because, i suppose, the minimum is calculated for each column

M.

 

[stkin]

Where are your data? How many columns?
Tell us the exact location of your data.

M.

The Conditional Formatting runs down each column, the formula you gave me works on those, now I need a formula that will total the number of cells that have red numbers in each row.

I hope this helps, can I load my file in this forum

Tommy

 

[ChandraAmgain]

Hi Stkin,

I think Marcelo Branco gave you a solution already. If not you better make custom formula with VB code. if you wish to make custom formula, Please let me know.


ChandraAmgain

 

[stkin]

Hi Stkin,

I think Marcelo Branco gave you a solution already. If not you better make custom formula with VB code. if you wish to make custom formula, Please let me know.


ChandraAmgain

His formula works on each column, but I can't get it to work on each row. If you can help that would be great.

Tommy

 

[Marcelo Branco]

Hi Tommy

Consider this data sample

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

O​

P​

Q​

R​

S​

T​

U​

6​

Expected Result​

7​

4​

4​

4​

4​

3​

4​

4​

4​

5​

3​

5​

4​

4​

4​

4​

4​

4​

4​

?​

8​

2​

3​

3​

3​

3​

4​

3​

3​

3​

3​

3​

3​

3​

3​

3​

3​

3​

3​

?​

9​

4​

4​

4​

4​

4​

4​

3​

4​

4​

4​

4​

4​

4​

4​

4​

3​

4​

4​

?​

<tbody>
</tbody>

Hi Tommy,

I have some questions:
1. Which cells should be highlighted (red font)?
2. What Conditional Format formula is used?
3. Expected results in column U?

Please, be specific

M.

 

[stkin]

Please, provide an example with at least 3 rows on each column.
We need more rows because, i suppose, the minimum is calculated for each column

M.

GOLF SKINS
	HOLE	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	TOTAL		TOTAL
	PAR	4	5	4	4	3	5	4	3	4	5	4	3	4	4	3	5	4	4	72	SKINS	MONEY
	MONEY PER HOLE	150	150	150	150	150	150	150	150	150	150	150	150	150	150	150	150	150	150	2,700	WON	WON
	PLAYER
1	TK	4	4	5	6	4	5	4	5	4	5	4	5	4	5	4	5	4	5	82		2,106
2	KO	5	4	4	3	3	5	3	6	5	4	5	4	5	4	5	4	5	4	78		2,106
3	BF	4	3	3														5		15		2,106
4	KE	5	2	4														5		16		2,106
5	DW	3	4	4														5		16		2,106
6	SK	4	4	4														5		17		2,106
7		4	4	4														5		17		2,106

<colgroup><col><col><col><col span="17"><col><col><col></colgroup><tbody>
</tbody>

I hope this helps, the row with TK is Row 7 and hole 1 is column C the total of red numbers would go in Column V which just shows bland on here example the row with TK the total is 6 cells with red numbers.

Thanks

 

[Marcelo Branco]

Try this formula in V7
=SUMPRODUCT(--(C7:T7=SUBTOTAL(5,OFFSET(C$7:T$200,0,COLUMN(C$7:T$200)-COLUMN(C$7),,1))))
copy down

BTW, shoudn't the result for C7:T7 be 7 (not 6)?
Min cells in row 7 --> H7, J7, K7, M7, O7, Q7 and S7

M.

 

[stkin]

THANK YOU THANK YOU THANK YOU

THAT DID IT

I CAN'T TELL YOU THANKS ENOUGH

GREAT JOB.

 

[Marcelo Branco]

You are welcome. Glad to help

M.