Forum Discussion
Solved
Excel refuses to accept formula
When I type in a or insert a formula, even if exactly off an Excel tutorial, it shows: "You've entered too few arguments" and I cannot get it to calculate any formula. I am trying to do a simple Cou...
Does it work when you open the attached file? I work with Excel 2013 and it works perfectly.
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.
