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: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=539235

=SUMIF(C:C,"Inbound",A:A)+SUMIF(C:C,"Inbound",B:B)

etc.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"stapleton2308"
wrote in message
news:stapleton2308.27c4xq_1146833750.0753@excelfor um-nospam.com...

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:
http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=539235

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 "Inbound" in
column C and sums A and B when it finds it. However, note you have a
typo in your example: "Outbouns". 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 - Sort C column - Ok
4. Select C and D column and rows.
5. Data- Subtotals - Ok
6. You can change the displayed summarisation level on the left side infront
of the Excel cells.

"stapleton2308" wrote:


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: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=539235