if then /lookup function
 

I want to sum up all the value such as "aa" instead of softing and using
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)


--
moni88
------------------------------------------------------------------------
moni88's Profile: http://www.excelforum.com/member.php...o&userid=33808
View this thread: http://www.excelforum.com/showthread...hreadid=535812

if then /lookup function
 

=SUMIF(B1:B6,"aa",C1:C6)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"moni88" wrote in
message ...

I want to sum up all the value such as "aa" instead of softing and using
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)


--
moni88
------------------------------------------------------------------------
moni88's Profile:
http://www.excelforum.com/member.php...o&userid=33808
View this thread: http://www.excelforum.com/showthread...hreadid=535812

if then /lookup function
 

hi!

=SUMIF(B1:B6,"aa",C1:C6)

-via135


moni88 Wrote:
I want to find "aa" and then sum up all the value in column C. The
function I use below 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)


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=535812

if then /lookup function
 

It's work. Thanks a lots.:)


--
moni88
------------------------------------------------------------------------
moni88's Profile: http://www.excelforum.com/member.php...o&userid=33808
View this thread: http://www.excelforum.com/showthread...hreadid=535812