sumif() without first argument

[lezawang]

Hi
I want to find the sum of cells which have values >20 . I tried sumif(range, criteria, sum_range). I thought since I know the conditon then no need for the first argument in sumif(). So i tried =sumif(">20", a1:a5) but did not work. Thank you so much.

[TABLE="width: 50"]
<tbody>[TR]
[TD]10[/TD]
[/TR]
[TR]
[TD]22[/TD]
[/TR]
[TR]
[TD]100[/TD]
[/TR]
[TR]
[TD]55[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

You need the first argument.
See this link to Office Support.
https://support.office.com/en-us/article/sumif-function-169b8c99-c05c-4483-a712-1697a653039b

 

[shaowu459]

Please have a try:
=SUMIF(A1:A5,">20")