Sum of filtered list values macro code needed

K

kiran66

New Member
Joined
Dec 8, 2020
Messages
13
Office Version
  1. 2019
Platform
  1. Windows
Hello everyone, I have a price list. I have to filter prices based on specific range which i will fix . specific range for below mentioned examples is price between 204 to 207 .The example I mentioned here.
i need sum value for extra column based on price range between 204 to 207.
ProductPriceextra
apple
200​
1450​
Filtered Value
2952​
grapes
205​
1452​
mango
206​
1500​
berry
700​
7000​
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
Assuming names price, extra have been created.
The formula is =SUMIFS(extra, price, ">=204", price, "<=207")
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Solved
Count Distinct Values in Filtered Table across Multiple Columns
Replies
6
Views
366
Fluff
Fluff
brendalpzm
  • Locked
  • Question
Populate an ActiveX combo box according to a List Box values
Replies
1
Views
256
Fluff
Fluff
W
  • Solved
Filter/Matching HELP
Replies
5
Views
301
Alex Blakenburg
A
W
  • Solved
LOGIC/SUM/FILTER Help
2
Replies
14
Views
524
Alex Blakenburg
A
Y
  • Solved
Macro to filter column containing values from list
Replies
6
Views
841
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,215,169
Messages
6,123,412
Members
449,098
Latest member
ArturS75

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top