Forum Discussion
DupreLombaard
Jan 01, 2022Copper Contributor
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...
- Jan 02, 2022
Does it work when you open the attached file? I work with Excel 2013 and it works perfectly.
DupreLombaard
Jan 02, 2022Copper Contributor
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.
OliverScheurich
Jan 02, 2022Gold Contributor
Does it work when you open the attached file? I work with Excel 2013 and it works perfectly.
- DupreLombaardJan 02, 2022Copper ContributorOliverScheurich
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.- SergeiBaklanJan 02, 2022Diamond Contributor
Great to know you sorted this out, thank you for the feedback.