Forum Discussion

Jupiter1's avatar
Jupiter1
Copper Contributor
May 19, 2020

Formula Help

Hi All,

I hope that someone can help with a formula i am trying to do. I have attached a visual explanation of the formula so far and what I want to additionally calculate. Below is the formula currently but i need to add further to it. Please see attached info to explain.

 =IF(ISBLANK(N2),0,SUMIFS(SHEET2!G:G,SHEET2!D:D,SHEET1!D2))+IF(ISBLANK(O2),0,SUMIFS(SHEET2!J:J,SHEET2!D:D,SHEET1!D2))+IF(ISBLANK(P2),0,SUMIFS(SHEET2!M:M,SHEET2!D:D,SHEET1!D2))+IF(ISBLANK(Q2),0,SUMIFS(SHEET2!P:P,SHEET2!D:D,SHEET1!D2))

 

I hope someone can help me with this.

Many thanks

excel

5 Replies

    • Jupiter1's avatar
      Jupiter1
      Copper Contributor
      May 19, 2020

      SergeiBaklan 

      Thank you for your quick response.

      The thing is I only want the level to calculate if column named ‘A’ or ‘C’ have markers. if either do then it can lookup level and add corresponding value.

      Hope that makes sense?

      Many thanks

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 19, 2020

        Jupiter1 

        With this you may add with lookup under the main formula condition where you check for the marker. 

Resources