Count SE with three options Excel 2007 [Solved]

    Goodnight

    I come to ask for help with a formula.


    I intend that, if there is nothing in B10, then nothing appears.

    If there is a number in B10, I want the formula to look for it in Scale April 2023_Cycle count.xls in the Scale tab from cell E7 to K37,

    if found, execute the formula, if not found, look for it in Scale April 2023_Cycle count. xls in the Scale Tab in cell AI7 to BZ37,

    if found, execute the formula, if not found, look for it in Scale April 2023_Cycle count.xls in the Scale Tab in cell CA7 to CD37,

    if not found anywhere, then stay in blank.

    =IF(B10="";"";COUNT.IF('[April 2023 scale_Cycle count.xls]Scale'!$E$7:$K$37;B10)/4)

    =IF(B10="";"";COUNT.IF('[April 2023 scale_Cycle count.xls]Scale'!$AI$7:$BZ$37;B10)/4)

    =IF(B10="";"";COUNT.IF('[April 2023 Scale_Cycle count.xls]Scale'!$CA$7:$CD$37;B10)/4)


    These are the three formulas that I intend to unite and become one ... but I am not able to do that.


    Could you please help me.


    Thanks Compliments

    Edited once, last by Carim: Removed Code Tags ().

    Hello,


    Thanks for using the Code Tags ONLY whenever you are posting a macro ...


    For standard text, there is no formatting required at all ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Like 1

    Good afternoon


    I'm sorry ...

    but I'm still learning how to work on the Forum,

    so I may have some flaws, ...

    my sincere apologies for what happened

    Compliments

    Edited once, last by Carim: Removed Code Tags ().

    Hi again,


    Can you see the difference between the way your text was displayed Originally (with Code Tags) ....

    and the current display .... once the Code Tags have been removed ...


    The Code Tags are represented by the little icon </> in the Top Menu ... only to be used for macros ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Like 1

    Hi,


    You can test following formula

    Code
    =IF(B10="";"";IF(COUNTIF('[April 2023 scale_Cycle count.xls]Scale'!$E$7:$K$37;B10)>0;COUNTIF('[April 2023 scale_Cycle count.xls]Scale'!$E$7:$K$37;B10)/4;IF(COUNTIF('[April 2023 scale_Cycle count.xls]Scale'!$AI$7:$BZ$37;B10)>0;COUNTIF('[April 2023 scale_Cycle count.xls]Scale'!$AI$7:$BZ$37;B10)/4;IF(COUNTIF('[April 2023 scale_Cycle count.xls]Scale'!$CA$7:$CD$37;B10)>0;COUNTIF('[April 2023 scale_Cycle count.xls]Scale'!$CA$7:$CD$37;B10)/4;""))))

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Thanks 1

  • Bikke

    Changed the title of the thread from “Count SE with three options Excel 2007” to “Count SE with three options Excel 2007 (Solved)”.

    Glad to hear you have solved your problem :thumbup:


    Thanks a lot for your Thanks AND for the Like 8)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Bikke

    Changed the title of the thread from “Count SE with three options Excel 2007 (Solved)” to “Count SE with three options Excel 2007 [Solved]”.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login