Need profit calculation formula

[rameshppc]

Hi good afternoon.

I am doing money transfer business and i need to entry every transactions in excel to calculate the profit. But it takes a long time and need your help to make it better.
[TABLE="width: 500"]
<tbody>[TR]
[TD]DATE
[/TD]
[TD]TDS
[/TD]
[TD]TRANSFER AMOUNT
[/TD]
[TD]PROFIT
[/TD]
[/TR]
[TR]
[TD]01/12/2018
[/TD]
[TD]2
[/TD]
[TD]5020
[/TD]
[TD]73
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 203"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]TRANSFER AMOUNT FROM

100
[/TD]
[TD]TRANSFER AMOUNT TO

1015.3
[/TD]
[TD]PROFIT

9
[/TD]
[/TR]
[TR]
[TD]1015.4
[/TD]
[TD]1515.5
[/TD]
[TD]14.5
[/TD]
[/TR]
[TR]
[TD]1515.6
[/TD]
[TD]2015.5
[/TD]
[TD]24.5
[/TD]
[/TR]
[TR]
[TD]2015.6[/TD]
[TD]2520[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]2520.1[/TD]
[TD]3020[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]3020.1[/TD]
[TD]3524.5[/TD]
[TD]45.5[/TD]
[/TR]
[TR]
[TD]3524.6[/TD]
[TD]4024.5
[/TD]
[TD]55.5[/TD]
[/TR]
[TR]
[TD]4024.6[/TD]
[TD]4527[/TD]
[TD]63[/TD]
[/TR]
[TR]
[TD]4527.1[/TD]
[TD]5027[/TD]
[TD]73[/TD]
[/TR]
[TR]
[TD]5027.1[/TD]
[TD]6038.8[/TD]
[TD]61.2[/TD]
[/TR]
[TR]
[TD]6038.9[/TD]
[TD]7039[/TD]
[TD]61[/TD]
[/TR]
[TR]
[TD]7039.1[/TD]
[TD]8043.5[/TD]
[TD]56.5[/TD]
[/TR]
[TR]
[TD]8043.6[/TD]
[TD]9048[/TD]
[TD]52[/TD]
[/TR]
[TR]
[TD]9048.1[/TD]
[TD]1050[/TD]
[TD]50
[/TD]
[/TR]
</tbody>[/TABLE]

The first table i am entering 3 columns and fourth coloum (profit) need formula based on the second table.
Hope its clear and pls help for formula

 

[Kamolga]

=SUMIFS(C7:C20,A7:A20,"<="&C2,B7:B20,">="&C2)

with table2 in A7:C20 and 5020 in C2, formula gives 73

 

[rameshppc]

Sir you are really great as you gave me excellent formula...

its working awsome..

Thanks a lot...

 

[Kamolga]

Sir you are really great as you gave me excellent formula...

its working awsome..

Thanks a lot...

You are welcome. Thanks for the feedback.