Forum Discussion
Solved
countif in a table with formulas
I am sorry to ask but I have not found a clear answer to this concrete case. I simply have a table... in my case I have dates eg 2022-10-01, 2022-11-01, 2022,-10-02, 2022-09-01, 2022-10-04 ---- and ...
With the following formula you get your desired result:
=SUM(--(MONTH(Table1[Date])=10))Please adjust table name and column header.
With the following formula you get your desired result:
=SUM(--(MONTH(Table1[Date])=10))Please adjust table name and column header.
- uau!... I would have never come to this one!.... man!......
Still looks a mystery... I would think the SUMIFS was the one to go.
but YOU NAILED it
Thanks!!!as an add on - why doesn’t the criteria work on the countifs?
seems the criteria can’t evaluate expressions - just make simple comparisons….is this a limitation of my version or is it excell?
thanks!
The criteria argument of COUNTIF must be something like ">0" or "January" or $B$2, not an expression that evaluates a range.
