Forum Discussion
Countif. on cell with a formula
I have a column in Sheet A with a formula which is only pointing to another cell in a different sheet (let say B). this other cell contains a date. When I try to count all cells containing for example month "october" it only work if I do it on sheet B, on sheet A it does not seem to see the result of the formula on that cell.
Cesar65 It should work. What's the exact formula? In the picture below, I have a list of months in A, that gets its value from a list in Sheet2. COUNTIF in C1 works as expected.
many thanks for you answer Riny. I think I have found my mistake myself, I was trying to count for example the cells containing a month, october for example. so I put the formula countif "oct.-21" but the cell was containing a full date like 21/10/2021 but showing oct.-21 because that the Date format I was using.
to solve it, I then have added a column with the function =TEXT(A2, "mmm") and contif "oct" on that column. it worked.
