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 a
follows:

Inbound total - £............A + B
Outbound total - £............A + B
Other total - £............A + B

help much appriacte

 

[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]...

 

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

 

[Guest]

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.