Conditions Help
 

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

Conditions Help
 

Hello Curtis

Try this:

=COUNTIF(A1:D1,"0.02")*3

Judith
--
Hope this helps


"Curtis" wrote:

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

Conditions Help
 

thx

"JudithJubilee" wrote:

Hello Curtis

Try this:

=COUNTIF(A1:D1,"0.02")*3

Judith
--
Hope this helps


"Curtis" wrote:

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