lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
<tbody>
</tbody>
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.
10 |
22 |
100 |
55 |
3 |
<tbody>
</tbody>