Forum Discussion

Glooby K's avatar
Glooby K
Copper Contributor
Jan 08, 2018

Formula that works only on original spreadsheet - Not on copy

Hello Excel's specialist, I'm a good user of Excel but I'm stuck on this one. I have an Excel sheet managing 2017 stuff with this formula >> =COUNTIF(INDIRECT(MATCH($E$9,B:B) & ":" & MATCH($E$9,B...
Formulas & Functions
Need Help
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor

Karim,

 

I can't find any problems with the formula. It works in sheet 2017 and in sheet 2018.

 

Glooby K's avatar
Glooby K
Copper Contributor
Jan 09, 2018

Hi Lewin,

thanks for your attention on my question.

it's strange...

If you look at the formula in cell H9 the result should be "12" on the 6th of June.

There is no error message but it doesn't work as expected.

 

I did some tests and it appears that it's related to the dates column. I changed B32 by 09/01/2018 and B20 by 09/01/2018 >> In H9 I should find the number of times "TRM" is counted on the line 32.

It doesn't work. When I put back 2017, it works back.

There is something with the dates but I don't know what ?

 

Karim

 

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Jan 10, 2018

    Karim,

     

    why should H9 show 12 as a result for 6th of June when there are no entries in that row?

    It seems you are talking about a totally different workbook. Perhaps you should upload that workbook.

     

     

Resources