software

I want to sum up all the value such as quot;aaquot; 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=quot;aaquot;,C1:C6),0)--
moni88
------------------------------------------------------------------------
moni88's Profile: www.excelforum.com/member.php...oamp;userid=33808
View this thread: www.excelforum.com/showthread...hreadid=535812=SUMIF(B1:B6,quot;aaquot;,C1:C6)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;moni88quot; gt; wrote in
message ...
gt;
gt; I want to sum up all the value such as quot;aaquot; instead of softing and using
gt; function sum/if. But it doesn't work. Any expect can help? Thanks.
gt;
gt; 1 aa 10
gt; 2 bb 40
gt; 3 aa 20
gt; 4 cc 25
gt; 5 aa 10
gt; 6 bb 44
gt;
gt; =SUM(IF(B1:B6=quot;aaquot;,C1:C6),0)
gt;
gt;
gt; --
gt; moni88
gt; ------------------------------------------------------------------------
gt; moni88's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33808
gt; View this thread: www.excelforum.com/showthread...hreadid=535812
gt;

hi!

=SUMIF(B1:B6,quot;aaquot;,C1:C6)

-via135moni88 Wrote:
gt; I want to find quot;aaquot; and then sum up all the value in column C. The
gt; function I use below doesn't work. Any expect can help? Thanks.
gt;
gt; 1 aa 10
gt; 2 bb 40
gt; 3 aa 20
gt; 4 cc 25
gt; 5 aa 10
gt; 6 bb 44
gt;
gt; =SUM(IF(B1:B6=quot;aaquot;,C1:C6),0)--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=535812
It's work. Thanks a lots.--
moni88
------------------------------------------------------------------------
moni88's Profile: www.excelforum.com/member.php...oamp;userid=33808
View this thread: www.excelforum.com/showthread...hreadid=535812