Forum Discussion
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 Countif calculation on a small dataset.
I use Office 365 Version 18.2106.12410.0 and an updated 2021 Excel.
The formula I am trying to use is: =COUNTIF(A2:A30\L2) in the following table:
| Series 1 | Series 2 | Series 3 | Series 4 | Series 5 | Lead | Sum | Average | Number | |||
| 2 | 5 | 11 | 19 | 23 | 1 | 60 | 12 | 1 | |||
| 3 | 18 | 21 | 24 | 28 | 1 | 94 | 19 | 2 | |||
| 3 | 7 | 17 | 19 | 25 | 2 | 71 | 14 | 3 | |||
| 4 | 7 | 20 | 22 | 28 | 2 | 81 | 16 | 4 | |||
| 4 | 9 | 20 | 24 | 31 | 2 | 88 | 18 | 5 | |||
| 5 | 18 | 26 | 35 | 39 | 2 | 123 | 25 | 6 | |||
| 7 | 13 | 44 | 46 | 49 | 2 | 159 | 32 | 7 | |||
| 4 | 13 | 21 | 29 | 31 | 3 | 98 | 20 | 8 | |||
| 4 | 14 | 21 | 29 | 33 | 3 | 101 | 20 | 9 | |||
| 5 | 16 | 21 | 30 | 35 | 3 | 107 | 21 | 10 | |||
| 5 | 16 | 22 | 30 | 38 | 4 | 111 | 22 | 11 | |||
| 5 | 16 | 24 | 31 | 39 | 4 | 115 | 23 | 12 | |||
| 6 | 16 | 26 | 35 | 43 | 4 | 126 | 25 | 13 | |||
| 7 | 17 | 26 | 37 | 45 | 4 | 132 | 26 | 14 | |||
| 27 | 30 | 33 | 38 | 49 | 5 | 177 | 35 | 15 | |||
| 11 | 20 | 24 | 29 | 31 | 7 | 115 | 23 | 16 | |||
| 8 | 18 | 27 | 38 | 47 | 7 | 138 | 28 | 17 | |||
| 9 | 18 | 30 | 40 | 48 | 9 | 145 | 29 | 18 | |||
| 4 | 16 | 39 | 40 | 50 | 9 | 149 | 30 | 19 | |||
| 11 | 19 | 33 | 40 | 48 | 10 | 151 | 30 | 20 | |||
| 11 | 19 | 24 | 31 | 47 | 11 | 132 | 26 | 21 | |||
| 5 | 7 | 11 | 19 | 38 | 14 | 80 | 16 | 22 | |||
| 15 | 19 | 34 | 40 | 49 | 14 | 157 | 31 | 23 | |||
| 15 | 20 | 36 | 42 | 49 | 14 | 162 | 32 | 24 | |||
| 19 | 24 | 37 | 44 | 49 | 15 | 173 | 35 | 25 | |||
| 20 | 28 | 37 | 45 | 50 | 16 | 180 | 36 | 26 | |||
| 23 | 32 | 39 | 46 | 50 | 16 | 190 | 38 | 27 | |||
| 6 | 14 | 20 | 30 | 33 | 19 | 103 | 21 | 28 | |||
| 29 | 36 | 44 | 48 | 50 | 19 | 207 | 41 | 29 |
Does it work when you open the attached file? I work with Excel 2013 and it works perfectly.
6 Replies
=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.
