software

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/A5.00%The total points, that are captured in column E are 6

Thanks
Hello Curtis

Try this:

=COUNTIF(A11,quot;gt;0.02quot;)*3

Judith
--
Hope this helpsquot;Curtisquot; wrote:

gt; I have a column(s) that can contain any value fron 0% to 100%, even #N/A.
gt; What I need to do is look at each column and if the value is greater than 2%
gt; I need that column to sum to 3.
gt;
gt; For ex:
gt;
gt; Col A Col B Col C Col D
gt;
gt; 0.00%3.56%#N/A5.00%
gt;
gt;
gt; The total points, that are captured in column E are 6
gt;
gt; Thanks
gt;
gt;

thx

quot;JudithJubileequot; wrote:

gt; Hello Curtis
gt;
gt; Try this:
gt;
gt; =COUNTIF(A11,quot;gt;0.02quot;)*3
gt;
gt; Judith
gt; --
gt; Hope this helps
gt;
gt;
gt; quot;Curtisquot; wrote:
gt;
gt; gt; I have a column(s) that can contain any value fron 0% to 100%, even #N/A.
gt; gt; What I need to do is look at each column and if the value is greater than 2%
gt; gt; I need that column to sum to 3.
gt; gt;
gt; gt; For ex:
gt; gt;
gt; gt; Col A Col B Col C Col D
gt; gt;
gt; gt; 0.00%3.56%#N/A5.00%
gt; gt;
gt; gt;
gt; gt; The total points, that are captured in column E are 6
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt;