## View Poll Results: IF AND OR Statement, not working need help

Voters
0. This poll is closed
• IF AND or OR function is not giving correct result, need help

0 0%
• IF Logical function

0 0%
Multiple Choice Poll.

# Thread: IF AND OR excel statement

1. Register for a FREE account, and/
or Log in to avoid these ads!

Any use???

2. Originally Posted by AliGW
You just need to add another exclusion criterion:

=IF(SUM(COUNTIF(\$F6:\$AC6,{"C","Z",""}))-COUNTIFS(\$F\$5:\$AC\$5,"Status",\$F6:\$AC6,"",\$F6:\$AC6,NA)>=12,"Complete","No")
AliGW, let me clarify may was not clear earlier.

See attached workbook...v2

In summary tab the cell E3 to E14 and F3 to F14 I have manually input the results. I want formulas to pull results from the detail tab.

In cell E3 I want to put number by only counting: C's, Z's, O's and I's.
In cell F3 I want to put number by only counting: C's and Z;s
the reference are in detail tab in col JEN and Status.

for example I will check JEN0034 in both tab then count C,Z,O and I. I have put
7 in E3 (because there are, 5 Z's, 1 C and 1 O; I do not want to count #N/A) and
6 in F3 ( in this cell I have only counted C's and Z's i.e.
5 Z's, 1 C)

See the row 53 of the detail tab has the reference (Column JEN.. is unique in the both tabs)

Thank you

3. This is getting increasingly complex. Are you going to be introducing any further complexities? If so, it would be easier to know that now before spending even more time on this. You really should give the whole, 'real' picture at the outset.

I will have another look for you.

EDIT: Had another look, and I am afraid I don't have time for this right now. It's a whole new ask. Hopefully someone else will step in.

Good luck with it!

4. Originally Posted by AliGW
This is getting increasingly complex. Are you going to be introducing any further complexities? If so, it would be easier to know that now before spending even more time on this. You really should give the whole, 'real' picture at the outset.

I will have another look for you.

EDIT: Had another look, and I am afraid I don't have time for this right now. It's a whole new ask. Hopefully someone else will step in.

Good luck with it!
Thank you AliGW.

This is the last whole real picture. there will not be any further addition/complexities to it. I am not in a rush (may be in a week or so)

Thank you again.

Page 4 of 4 First ... 2 3 4

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•