Index formula that sums column

[usnapoleon]

I am trying to sum up various numbers specific to certain outlets, using an Index and Match formula and I feel I'm close but the last part of my formula is off (I'm trying to repurpose an existing formula). I was hoping someone could give me the last bit to get over the finish line.

The formula is looking at any amount for the 2nd that is related to the Market. I'll do one for Restaurant and Activities too, but the formula being shown is Market oriented. Sometimes it's just one number being added, like the 25.69, but sometimes its multiple numbers.

Thank you!!

 

[kweaver]

It would help others if you changed your profile to indicate what version of Excel you run AND use XL2BB to post sample data and expected results.

 

[DanteAmor]

Try this:

Dante Amor
	A	B	C	D
6		1	2	3
99
100
101
123
124	Market		25.69	2
125	Market		10.00	3
126	Market
127	Restaurant		1.00
128	Restaurant		2.00
129	Restaurant		3.00
130	Activities		4.00
131	Activities		5.00
132	Activities		6.00
133
134
135
136
137
138
139	Total
140
141
142	Market	0.00	35.69	5.00
143	Restaurant	0.00	6.00	0.00
144	Activities	0.00	15.00	0.00
Hoja2

Cell Formulas
Range	Formula
B142:D144	B142	=SUMIF($A$101:$A$138,$A142,B$101:B$138)

 

[usnapoleon]

Try this:

Dante Amor
	A	B	C	D
6		1	2	3
99
100
101
123
124	Market		25.69	2
125	Market		10.00	3
126	Market
127	Restaurant		1.00
128	Restaurant		2.00
129	Restaurant		3.00
130	Activities		4.00
131	Activities		5.00
132	Activities		6.00
133
134
135
136
137
138
139	Total
140
141
142	Market	0.00	35.69	5.00
143	Restaurant	0.00	6.00	0.00
144	Activities	0.00	15.00	0.00
Hoja2

Cell Formulas
Range	Formula
B142:D144	B142	=SUMIF($A$101:$A$138,$A142,B$101:B$138)

Hi!! Wow, that worked. A much simpler formula than I was thinking, thank you soooo much!!!!!!