Forum Discussion
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()...
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()
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.
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?