Excel Macros Filtered the data

hello everyone this is kiran kumar.

i am beginner in excel macros and i am trying to learn macros which will help me in strengthen my professional career.

i am looking to

i need macro code for filtered data. when i run the code i need the data to be filtered based on particular condition after that i need total of the filtered values of another coloumn at the same time.
example:
S.No Book Level Price
1 ABC 3 400
3 ABCC 4 500
4 ABCD 5 600
5 ABCE 6 500
6 ABDE 8 400


Need Code for Level between 4 to 5
Price total 1100