I am facing following problem:
I have a table with car specifications. I want to create a distribution table.
Conditions:
If mileage is between 0 - 5000 sum column WW (only values based on the criteria of 0-5000)
IF mileage is between 5,000 - 10,000 sum column WW (only values based on the criteria of 0-5000)
IF mileage is between 10,000 - 20,000 sum column WW (only values based on the criteria of 0-5000)
etc.
mileage data is stored in column H
How do I do that? SUMIF?
Can you guys please provide me with a formula that sums column WW based on the conditions?
thank you
Bookmarks