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)
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)
Last edited by moni88; 04-25-2006 at 12:28 AM.
hi!
=SUMIF(B1:B6,"aa",C1:C6)
-via135
Originally Posted by moni88
=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
It's work. Thanks a lots.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks