SOLVED

Excel refuses to accept formula

New Contributor

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 1Series 2Series 3Series 4Series 5 Lead SumAverage Number
25111923 1 6012 1
318212428 1 9419 2
37171925 2 7114 3
47202228 2 8116 4
49202431 2 8818 5
518263539 2 12325 6
713444649 2 15932 7
413212931 3 9820 8
414212933 3 10120 9
516213035 3 10721 10
516223038 4 11122 11
516243139 4 11523 12
616263543 4 12625 13
717263745 4 13226 14
2730333849 5 17735 15
1120242931 7 11523 16
818273847 7 13828 17
918304048 9 14529 18
416394050 9 14930 19
1119334048 10 15130 20
1119243147 11 13226 21
57111938 14 8016 22
1519344049 14 15731 23
1520364249 14 16232 24
1924374449 15 17335 25
2028374550 16 18036 26
2332394650 16 19038 27
614203033 19 10321 28
2936444850 19 20741 29

 

 

6 Replies

@DupreLombaard 

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

@Quadruple_Pawn 

 

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.

2022-01-02 (3).png2022-01-02 (2).png2022-01-02 (1).png2022-01-02.png

@DupreLombaard 

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

@DupreLombaard 

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

@Quadruple_Pawn

Many thanks, it now works. I first got it working in your spreadsheet and then ...

@Sergei Baklan

I changed the regional settings in my spreadsheet, copied the formula from @Quadruple_Pawn and "boom", it's working.

Many thanks for your assistance.

@DupreLombaard 

Great to know you sorted this out, thank you for the feedback.