excel formula help

  • hi all,

    i am new here, but i love the place, i have a question, i have a formula, but it is a bit long, i need to make it shorter, an example is below:


    i will be having about 30 sheets so it is very long, anyone can help me to simplify this,

    thanks in advance,

  • Re: excel formula help

    thanks for the advise, i will be minimizing as possible, but i have 81 agents, and everyday, there is a audit report comes with yes or no's which has 20 parameters, i will be counting yes or no's on each parameter, if you have any other advise, please helpme on this issue, as it's in my head all the time, it does not make me sleep :)

Participate now!

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