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.
Page 4 of 4 FirstFirst ... 2 3 4
Results 31 to 34 of 34

Thread: IF AND OR excel statement

  1. #31
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,061
    Articles
    0
    Excel Version
    Office 365 Subscription


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

    Any use???
    Ali
    Enthusiastic self-taught user of MS Excel!

  2. #32
    Quote Originally Posted by AliGW View Post
    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

    Attached Files Attached Files

  3. #33
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,061
    Articles
    0
    Excel Version
    Office 365 Subscription
    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!
    Last edited by AliGW; 2018-04-16 at 07:44 PM.
    Ali
    Enthusiastic self-taught user of MS Excel!

  4. #34
    Quote Originally Posted by AliGW View Post
    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 FirstFirst ... 2 3 4

Tags for this Thread

Posting Permissions

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