VBA code needed

[mjl78]

I am focusing on two columns of data (the number of rows can vary). The first column has monetary values, and the second column has cost percents
EX.
COL N COL O
Row1 500,000 .0134
Row 2 690,000 .0150




Row "N" 6,000,000 .2500

I already sorted columns N and O by small to largerst value in Row N
I know how to calculate the last row

We want to get the col O sums as follows:
range 1: ($400K-750K)
range 2: (750K-2M)
range 3: ($2M-$5M)
range 4: (>5M)

Note: row 1 $ can be > that range 1 and perhaps other ranges as well. In this instance the value for the sums must equal "zero"

What is the best logic and vba code to obtain the required data?

Thanks very much

 

[venkat1926]

do you insist of a macro. see a spreadsheet solution here.

see your sheet . data is there in column N and O (N is formatted with commas,and O as dour decimal places.

the range1 etc are entered inc columns F,G H
in range 4 the maximum value is also entered (you can change it)
see the formula in I1 which is copied down

will this not do????? for easy reading format column I as number with four decimal places.

Excel Workbook
	F	G	H	I	J	K	L	M	N	O
1	range1	400,000	750,000	0.0284					500,000	0.0134
2	range2	750,000	2,000,000	2.378					690,000	0.0150
3	range3	2,000,000	5,000,000	4.688					1,029,000	0.7970
4	range4	5,000,000	10,000,000	1.524					1,250,000	0.6720
5									1,348,000	0.1620
6									1,471,000	0.1320
7									1,620,000	0.6150
8									2,066,000	0.7690
9									2,092,000	0.5920
10									2,453,000	0.1090
11									2,513,000	0.6360
12									2,577,000	0.3870
13									3,276,000	0.1420
14									3,305,000	0.8860
15									3,490,000	0.8870
16									4,890,000	0.2800
17									5,290,000	0.3240
18									5,317,000	0.0630
19									5,707,000	0.3480
20									5,724,000	0.4900
21									5,930,000	0.2990
Sheet1