Forum Discussion
Excel refuses to accept formula
Does it work when you open the attached file? I work with Excel 2013 and it works perfectly.
=COUNTIF($A$2:$A$30,L2)
Do you want to count the number of occurances of L2, L3, L4 and so on in Series 1 which is A2:A30 in your example?
Yes, I want to count the number of times a number occurs in a series.
I copied your formula into the spreadsheet, but it returned the same negative response as I previously found. I am going to try and insert screen prints to show the situation. I suspect that it has something to do with the Microsoft subscription or my setup. All cells are set as numbers. I have set automatic calculation.
Does it work when you open the attached file? I work with Excel 2013 and it works perfectly.
- OliverScheurich
Many thanks, it now works. I first got it working in your spreadsheet and then ...
SergeiBaklan
I changed the regional settings in my spreadsheet, copied the formula from OliverScheurich and "boom", it's working.
Many thanks for your assistance.Great to know you sorted this out, thank you for the feedback.
Perhaps you shall use semicolons instead of commas, depends on your regional settings.
It's always better to take formula from sample file, not from the text in post.
