Matching Rows and Colums SUM

[zapppsr]

-- broken image removed --
Please, help me on this one!!

 

[Robert Mika]

Your link is not being seen correctly try to wrap in

 

[zapppsr]

-- broken image removed --

Now lets see on Imageshack

 

[zapppsr]

Prefferrably, one that uses as an interval, B3:H7

 

[T. Valko]

Prefferrably, one that uses as an interval, B3:H7

Based on your screencap...

Enter this formula in C10:

=SUMIF($C$3:$H$3,C$9,$C4:$H4)

Copy across to D10 then down to C13:D13

 

[zapppsr]

Yes. This works, but... I'm supposed to use Units as a criteria, cause they can change... or not be presented in the same order...

And, thank you very much for the quick anwer. Thats why I use and recommend this Board.

 

[T. Valko]

Yes. This works, but... I'm supposed to use Units as a criteria, cause they can change... or not be presented in the same order...

And, thank you very much for the quick anwer. Thats why I use and recommend this Board.

OK, try this...

Book1
	B	C	D	E	F	G	H
3	_	A	A	A	B	B	B
4	Unit1	10	20	30	40	50	60
5	Unit2	70	80	90	100	110	120
6	Unit3	130	140	150	160	170	180
7	Unit4	190	200	210	220	230	240
8	_	_	_	_	_	_	_
9	_	A	B	_	_	_	_
10	Unit1	60	150	_	_	_	_
11	Unit4	600	690	_	_	_	_
12	Unit2	240	330	_	_	_	_
13	Unit3	420	510	_	_	_	_
Sheet1

Formula entered in C10:

=SUMIF($C$3:$H$3,C$9,INDEX($C$4:$H$7,MATCH($B10,$B$4:$B$7,0),0))

Copy across to D10 then down to C13:D13

 

[zapppsr]

PROBLEM SOLVED! Thank you very much.

Thats what I needed, learn to work with INDEX and MATCH. They are kinda strange until you get to know them.

I guess I can change the Intervals by Names, if I want, right...?

Thanks again. I love this borad, full of experts!

 

[T. Valko]

I guess I can change the Intervals by Names, if I want, right...?

If you mean the units can be in any order in the data table, yes!

I love this borad, full of experts!

I know. I just wish I was one of them!

PROBLEM SOLVED! Thank you very much.

You're welcome and thanks for the feedback!