SOLVED

New 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 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

6 Replies

# Re: Excel refuses to accept formula

=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?

# Re: Excel refuses to accept formula

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.

# Re: Excel refuses to accept formula

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.

best response confirmed by DupreLombaard (New Contributor)
Solution

# Re: Excel refuses to accept formula

Does it work when you open the attached file? I work with Excel 2013 and it works perfectly.