Test ranges used to answer this post:
https://excelfox.com/forum/showthrea...ll=1#post13401

Before:

_____ Workbook: Actual File.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
1
 Exchange Symbol Series/Expiry Open High Low Prev Close LTP
2
 NSE ASHOKLEY EQ
65
65.35
60.55
63.3
63.3
1
1
60
1.055
1.055
54
56.97
3
 NSE BANKBARODA EQ
62.1
62.95
56.15
56.65
56.65
1
6
60
0.944167
5.665
54
50.985
4
 NSE BEL EQ
66.15
66.75
62.4
65.65
65.65
1
6
60
1.094167
6.565
54
59.085
5
 NSE EQUITAS EQ
82
82.05
71
73.05
73.05
1
1
60
1.2175
1.2175
54
65.745
6
 NSE FEDERALBNK EQ
68
68.45
62.45
63.1
63.1
1
6
60
1.051667
6.31
54
56.79
7
 NSE GAIL EQ
85
88.8
79.1
79.95
79.95
1
6
60
1.3325
7.995
54
71.955
8
 NSE IDFCFIRSTB EQ
32.1
32.35
27.2
27.55
27.55
1
60
0.459167
0.459167
54
24.795
9
 NSE IOC EQ
93
93.65
87.25
87.9
87.9
1
60
1.465
1.465
54
79.11
10
 NSE L&TFH EQ
90
91.55
80.5
81.65
81.65
6
51
1.60098
9.605882
54
86.45294
11
Worksheet: Sheet1 (2)

_____ Workbook: 2.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
1
 Stock Name data data data data data data data data data data data data data data
2
 ACC
100
108
120
128
134
151
6534
30
90
97
103
3
 ADANIENT
101
109
121
127
135
122
782
40
92
98
4
 ADANIPORTS
102
110
122
16
137
177
10
50
93
99
104
5
 ASHOKLEY
1
2
3
4
5
16
137
177
6
 ANJALIPHARMA
10
50
93
99
5
102
110
122
9
10
11
7
 SUNTECK
11
12
13
14
15
16
17
18
19
20
21
22
23
8
Worksheet: Sheet1 (5)

_____ Workbook: Actual File.xlsx ( Using Excel 2007 32 bit )
Row\Col
O
P
Q
R
S
6
6.31
54
56.79
7
7.995
54
71.955
 Total Fund Amount
8387.320769
8
0.459167
54
24.795
 Current Fund Amount
9000
9
1.465
54
79.11
 Fund Allocated
8000
10
9.605882
54
86.45294
 Profit Amount
1000
11
 Sum is
551.8879
Worksheet: Sheet1 (2)

_____ Workbook: Actual File.xlsx ( Using Excel 2007 32 bit )
Row\Col
Q
2
56.97
3
50.985
4
59.085
5
65.745
6
56.79
7
71.955
8
24.795
9
79.11
10
86.45294
11
=SUM(Q2:Q10)
Worksheet: Sheet1 (2)


In this example sum of column Q is less than Range S10 value so nothing is done