Can Someone Help????

[stapleton2308]

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

[Bob Phillips]

=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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Dave O]

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.)

[Zsolt Dubovanszky]

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
>
>