Joining Column Data

[rstangroom]

Hi All

I essential have three columns

A) Work From Type
B) Project Price

Column A contains 5 different types
Column B contains the Project Price

In column A there may be multiples of the same type and I want to create a graph that shows me:
How many of each type there are and how much each type has brought in.

Recommendation £1,800.00
Previous Customer £1,200.00
Previous Customer £1,600.00
Friend £1,500.00
Recommendation £2,800.00
Customer £800.00
Search £2,000.00
Search £1,800.00
Customer £1,100.00
Customer £6,100.00
Customer £1,800.00
Customer £1,800.00
Customer £800.00
Friend £1,600.00
Customer £4,400.00
Search £1,200.00
Search £1,800.00
Search £1,800.00
Recommendation £1,800.00
Customer £1,600.00
Customer £2,400.00

I would like to see this displayed like this – but I don’t know how:

Type No. Value
Recommendation 3 £6,400.00
Previous Customer 2 £2,800.00
Friend 2 £3,100.00
Customer 9 £20,800.00
Search 5 £8,600.00


Can anyone help?

 

[Jeffrey Mahoney]

1) Pivot Table
2) Build a separate table and use Sumifs formulas

Next post will be a formula

 

[Steve=True]

Hi Rstangroom,

I would recommend that you create a pivot table and then add a pivot chart to the pivot table. Here is a tutorial:
how-to-create-a-dynamic-excel-pivot-table-dashboard-chart

Steve=True

 

[Jeffrey Mahoney]

Cell E2: Recommendation
Cell F2: =SUMIFS($B$2:$B$22,$A$2:$A$22,E2)
Range A2:A22 contains the Work From Type List
Range B2:B22 contains the Project Prices

Range E2:E6 contains a unique list of Work From Types

 

[rstangroom]

Thank you Steve and Jeffrey

 

[Steve=True]

Anytime