software

I have the following data
A B C
?3000 ?250 Inbound
?3000 ?150 Inbound
?1500 ?100 Outbound
?2500 ?250 Other
?5000 ?350 Outbouns
?6000 ?450 Inbound
?1500 ?150 Outbound
?3000 ?250 Other

i want to be able to add them up, so in a serperate cell(s) it looks as
follows:

Inbound total - ?............A B
Outbound total - ?............A B
Other total - ?............A B

help much appriacted--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: www.excelforum.com/member.php...oamp;userid=30878
View this thread: www.excelforum.com/showthread...hreadid=539235=SUMIF(C:C,quot;Inboundquot;,A:A) SUMIF(C:C,quot;Inboundquot;,B:B)

etc.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;stapleton2308quot; gt;
wrote in message
news:stapleton2308.27c4xq_1146833750.0753@excelfor um-nospam.com...
gt;
gt; I have the following data
gt; A B C
gt; ?3000 ?250 Inbound
gt; ?3000 ?150 Inbound
gt; ?1500 ?100 Outbound
gt; ?2500 ?250 Other
gt; ?5000 ?350 Outbouns
gt; ?6000 ?450 Inbound
gt; ?1500 ?150 Outbound
gt; ?3000 ?250 Other
gt;
gt; i want to be able to add them up, so in a serperate cell(s) it looks as
gt; follows:
gt;
gt; Inbound total - ?............A B
gt; Outbound total - ?............A B
gt; Other total - ?............A B
gt;
gt; help much appriacted
gt;
gt;
gt; --
gt; stapleton2308
gt; ------------------------------------------------------------------------
gt; stapleton2308's Profile:
www.excelforum.com/member.php...oamp;userid=30878
gt; View this thread: www.excelforum.com/showthread...hreadid=539235
gt;
With the sample data you posted in A1:C8 and the words Inbound,
Outbound, and Other in cells A10:A12, I used this formula in cell B10:
=SUMPRODUCT(--(A10=$C$1:$C$8),$A$1:$A$8) SUMPRODUCT(--(A10=$C$1:$C$8),$B$1:$B$8)
.... which you can copy into B11 and B12.

Note that spelling is critical. This formula looks for quot;Inboundquot; in
column C and sums A and B when it finds it. However, note you have a
typo in your example: quot;Outbounsquot;. This will cause your outbound total
to be mis-stated- I suggest using a checksum to compare the totals.
(Please note- I'm not pontificating or deliberately pointing out
errors, only trying to emphasize the importance of spelling for this
formula.)
Fix the 4th ros you misspeled: Outbouns to Outbound

1. Create column D with formula =A B
2. Select the whole table
3. Data -gt; Sort gt; C column -gt; Ok
4. Select C and D column and rows.
5. Data-gt; Subtotals -gt; Ok
6. You can change the displayed summarisation level on the left side infront
of the Excel cells.

quot;stapleton2308quot; wrote:

gt;
gt; I have the following data
gt; A B C
gt; 拢3000 拢250 Inbound
gt; 拢3000 拢150 Inbound
gt; 拢1500 拢100 Outbound
gt; 拢2500 拢250 Other
gt; 拢5000 拢350 Outbouns
gt; 拢6000 拢450 Inbound
gt; 拢1500 拢150 Outbound
gt; 拢3000 拢250 Other
gt;
gt; i want to be able to add them up, so in a serperate cell(s) it looks as
gt; follows:
gt;
gt; Inbound total - 拢............A B
gt; Outbound total - 拢............A B
gt; Other total - 拢............A B
gt;
gt; help much appriacted
gt;
gt;
gt; --
gt; stapleton2308
gt; ------------------------------------------------------------------------
gt; stapleton2308's Profile: www.excelforum.com/member.php...oamp;userid=30878
gt; View this thread: www.excelforum.com/showthread...hreadid=539235
gt;
gt;