M
moni88
I want to sum up all the value such as "aa" instead of softing and usin
function sum/if. But it doesn't work. Any expect can help? Thanks.
1 aa 10
2 bb 40
3 aa 20
4 cc 25
5 aa 10
6 bb 44
=SUM(IF(B1:B6="aa",C1:C6),0
function sum/if. But it doesn't work. Any expect can help? Thanks.
1 aa 10
2 bb 40
3 aa 20
4 cc 25
5 aa 10
6 bb 44
=SUM(IF(B1:B6="aa",C1:C6),0