Conditions Help

[Guest]

I have a column(s) that can contain any value fron 0% to 100%, even #N/A.
What I need to do is look at each column and if the value is greater than 2%
I need that column to sum to 3.

For ex:

Col A Col B Col C Col D

0.00% 3.56% #N/A 5.00%


The total points, that are captured in column E are 6

Thanks

 

[Guest]

Hello Curtis

Try this:

=COUNTIF(A11,">0.02")*3

Judith

 

[Guest]

thx

Hello Curtis

Try this:

=COUNTIF(A11,">0.02")*3

Judith