2 Replies Latest reply on Feb 5, 2018 3:07 AM by p.agard

    SUMIF in Adobe pro XI, equivalent to Excel=SUM.IF(C7:C68;C78;D7:D68

    p.agard

      I have tried every SUMIF formula on these forums. But none of them worked for me. So I really need your help to complete my formula.

       

      W

                20,00

      G

                80,00

       

       

      W

                23,00

      G

                40,00

      W

                  0,05

      G

                  2,00

       

       

      W

                  5,00

      G

                10,00

      W

                70,00

      G

                45,00

       

      What I am trying to do is get the total of all the amounts behind "W" and behind "G". So in this case it would be W= € 118,05 and G= € 177(These outcomres will come in "Text1.1" And in Text1.2".

       

      The row (from top to bottom) with G and W are called "Text9" and the second row is called "Text10". In  the rows there are 61 lines (Text9.1/Text9.2/Text9.3 etc).

       

      Can somebody please help me with this formula