Is it possible to look up individual prices in a range, and then calculate the number of items at individual price

[pedro-egoli]

This is share market related.
Just trying to see how many shares, at various prices , were traded during day.
This is an example of the csv file I want to work on

Excel Workbook
	A	B	C
1	Time	Price $	Volume
2	4:10:16 PM	1.055	2562
3	4:10:16 PM	1.055	25000
4	4:10:16 PM	1.05	10000
5	4:10:16 PM	1.045	10000
6	4:10:16 PM	1.03	2138
Course_of_sales_SYR_17Jul2019-1

Prices in column B will vary throughout the day and I want to be able to isolate the individual prices and then link the number of shares so that i have the total shares traded at a particular price for the day.
Somedays there may be over 2000 trades at various prices
Thanks

 

[AlanY]

like this?

Book1
	A	B	C
1	Time	Price $	Volume
2	4:10:16 PM	1.055	2562
3	4:10:16 PM	1.055	25000
4	4:10:16 PM	1.05	10000
5	4:10:16 PM	1.045	10000
6	4:10:16 PM	1.03	2138
7
8		Price $
9		1.055	27562
Sheet3

Cell Formulas
Range	Formula
C9	=SUMIF(B2:B6,B9,C2:C6)

 

[pedro-egoli]

Thanks for reply but no that is not what i am after.
What I need is to have the individual prices established in the range like this

Excel Workbook
	I	J	K	L
1	1.055	1.05	1.045	1.03
2	2562
Course_of_sales_SYR_17Jul2019-1

Once i have that I want to use a formula that will give me the total for each price.
The example i have is incorrect

 

[pedro-egoli]

This is the data I have

Excel Workbook
	B	C
1	Price $	Volume
2	1.055	2562
3	1.055	25000
4	1.05	10000
5	1.045	10000
6	1.03	2138
Course_of_sales_SYR_17Jul2019-1

I have worked out how to get the totals for each price as below

Excel Workbook
	I	J	K	L
1	1.055	1.05	1.045	1.03
2	27562	10000	10000	2138
Course_of_sales_SYR_17Jul2019-1

Is it possible to get the individual prices from B2:B6 to show in columns I1:L1?
That would make my day