| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count using 2 conditions, one of which being a "less than or equal to" - URGENT | Excel Discussion (Misc queries) | |||
| COUNT using multiple conditions | Excel Discussion (Misc queries) | |||
| More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
| average on 2 conditions | Excel Worksheet Functions | |||
Hybrid Mode
