Help: Sumif with criteria and between values

[Lammers73]

Hello,

thank you for taking time to read my message. I need some help, and after searching, I dont seem to find the answer. Hopefully, I can find help here.


The goal is to sum revenue based on a average sales price per item. I want to group this sales based on price point to learn the amount of revenue is being made between certain price points. So the basic data consists of sales figures with variables prices and variables revenue.
Basically it looks like

Sales price Revenue
$15 100$
$20 50$
$11 30$
$25 45$
$5 60$
$7 20$
etc

Next i want to know the revenue based on a price ranges

0-10$
10-15$
15-20$
25$

A formula should sum the total revenue made between these price brackets.


Thanks for your time. I am lost........

Marc

 

[kweaver]

Do you mean something like this?

Excel 2010
	A	B	C	D	E	F	G
1	Sales	Revenue		Low	High		Total
2	25	45		0	10		70
3	20	50		11	15		130
4	15	100		14	20		150
5	11	30		19	100		95
6	7	20
7	5	50
Sheet6

Cell Formulas
Range	Formula
G2	=SUMIFS($B$2:$B$7,$A$2:$A$7,">="&D2,$A$2:$A$7,"<="&E2)

 

[Lammers73]

Alright! exactly that! Thanks a lot!