Count Conditional formating data

[Marcus]

I have conditional formating setup on columns A, B, C and D. Depend on
result (if value is bigger then 0 cell is green) I would like to calculate
(count) in column E number of affected confidional data on columns 1-4.

for example
A B C D E
-5 10 -6 -8 1 (only one green cell - B)
2 -3 -6 36 2 (cells A and C are green depend on
conditional formating if vaule is bigger then 0)


How can I automatically calculate column E?

Thnx

 

[Pete_UK]

Try this in E1:

=COUNTIF(A11,">0")

then copy down.

Hope this helps.

Pete

 

[Marcus]

Try this in E1:

=COUNTIF(A11,">0")

then copy down.



Great, many thanks!

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete