Forum Discussion

Deleted's avatar
Deleted
May 18, 2018

Formula with more then one variable to calculate days

Hello, I am not sure how to attach the file. I think its there, but not sure. Formula found in column C: =SI(NB.SI(D10:II10,"x"),MIN(SI((D10:II10="x")*(D$8:II$8>=AUJOURDHUI()),D$8:II$8))-AUJOURDHUI(),0) The formula calculates the number of days that are there between the days date in 7C and the letter x found in the row, and I would like that the formula in column C now take into account the other letters such as V, M, F, Fc and Fr. I am not able to add them in formula as it is made. Thank you for your help. Pascale

Formulas & Functions
Need Help

3 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    May 18, 2018

    Pascale,

     

    Tabelle2!A:A6 contain the search criteria: x, V, M, F, Fc, Fr.

     

    =INDEX($8:$8,AGGREGATE(15,6,COLUMN(D10:II10)/COUNTIFS(Tabelle2!$A$1:$A$6,D10:II10),1))-TODAY()

     

    • Deleted's avatar
      Deleted
      May 19, 2018

      Bonjour, j'ai fais la traduction en francais et me donne ceci:

      =INDEX($8:$8,AGREGAT(15,6,COLONNE(D10:II10)/NB.SI(Tabelle2!$A$1:$A$6,D10:II10),1))-AUJOURDHUI()

      Par contre j'ai une erreur Nombre.

       

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        May 19, 2018

        Please respond in English.

         

        I suppose you are getting a #NUM? error.

        Did you fill in Tabelle2!A1:A6 with the search criteria? No blank cells?

         

         

         

         

Resources