Forum Discussion

deniztopcu's avatar
deniztopcu
Brass Contributor
Sep 12, 2023
Solved

Is there a solution to using the same function multiple times?

Hello, is there a shorter way to do such repetitive calculations? ı havent office 365.
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Sep 12, 2023

deniztopcu 

Somewhat shorter:

 

=TOPLA(TOPLA.ÇARPIM((B9<J9:AK9*{1;1,2;1,4;1,6;1,8;2})*(($J$8:$AK$8="QoQ")+($J$8:$AK$8="QoQ TTM"))*(J9:AK9<>""))-TOPLA.ÇARPIM((B9>J9:AK9*{1;1,2;1,4;1,6;1,8;2})*(($J$8:$AK$8="QoQ")+($J$8:$AK$8="QoQ TTM"))*(J9:AK9<>""))+
TOPLA.ÇARPIM((C9<J9:AK9*{1;1,2;1,4;1,6;1,8;2})*(($J$8:$AK$8="YoY")+($J$8:$AK$8="YoY TTM"))*(J9:AK9<>""))-TOPLA.ÇARPIM((C9>J9:AK9*{1;1,2;1,4;1,6;1,8;2})*(($J$8:$AK$8="YoY")+($J$8:$AK$8="YoY TTM"))*(J9:AK9<>"")))

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Sep 12, 2023

    HansVogelaar 

    Just started with it the same way, but didn't receive correct result. Could you please repeat formula in English?

  • deniztopcu's avatar
    deniztopcu
    Brass Contributor
    Sep 12, 2023
    I was excited when I saw the fiction. But he made an error.
    #NO
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Sep 12, 2023

        HansVogelaar 

        Thanks, found my mistake. Here is just formatting

        =SUM(
    SUMPRODUCT(
        (B9<J9:AK9*{1;1.2;1.4;1.6;1.8;2})*
        (($J$8:$AK$8="QoQ")+($J$8:$AK$8="QoQ TTM"))*
        (J9:AK9<>"")
    )-
    SUMPRODUCT(
        (B9>J9:AK9*{1;1.2;1.4;1.6;1.8;2})*
        (($J$8:$AK$8="QoQ")+($J$8:$AK$8="QoQ TTM"))*
        (J9:AK9<>"")
    )+

    SUMPRODUCT(
        (C9<J9:AK9*{1;1.2;1.4;1.6;1.8;2})*
        (($J$8:$AK$8="YoY")+($J$8:$AK$8="YoY TTM"))*
        (J9:AK9<>"")
    )-
    SUMPRODUCT(
        (C9>J9:AK9*{1;1.2;1.4;1.6;1.8;2})*
        (($J$8:$AK$8="YoY")+($J$8:$AK$8="YoY TTM"))*
        (J9:AK9<>"")
    )
)

Resources