Condition for Torow function

[pto160]

Is it possible to use conditions with the Torow function in conjunction with the choosecolumns function? In this example, the condition is order 300.

Book1
	A	B	C	D	E	F	G
1	Amount	Name	Receipt	Order
2	100	John Smith	a	300
3	200	Jane Joe	b	400
4	200	John Smith	c	300
5
6	Order
7	300	#NAME?	100	b	200	c	200
8
9	What I like
10	300	a	100	c	200
Sheet1

Cell Formulas
Range	Formula
B7	B7	=TOROW(CHOOSECOLS(A2:D4,3,1))

 

[Peter_SSs]

It is not clear to me exactly what you are trying to do, or where.
Giving a formula that does not do what you want doesn't tell us much about what you do want.

 

[pto160]

Hi there.
I am trying to sum column C by the voucher number (column B) and have create a unique list by order number to have a row for each order (column A). For example, order 100 has two vouchers- Voucher 1001 and 1003. The sum of voucher 1001 is 125 (50+75) and the sum for voucher 1003 is 10.
I was tying to use a hstack dynamic array formula using the torow function to do all of of this. Maybe I could use a separate lookup formula for the order number to lookup up by the voucher number.
For example, use a lookup formula for the voucher number 1001 to get the order number 100.

Book1
	A	B	C	D	E	F
1	Data
2	Order	Voucher	Amt
3	100	1001	50
4	100	1001	75
5	200	1002	50
6	100	1003	10
7
8	What I like
9	Order	Voucher	Amount		Voucher	Amount
10	100	1001	125		1003	10
11	200	1002	50
Sheet1

 

[Peter_SSs]

That layout might be a bit tricky, but what about this?

pto160.xlsm
	A	B	C
1	Data
2	Order	Voucher	Amt
3	100	1001	50
4	100	1001	75
5	200	1002	50
6	100	1003	10
7
8	What I like
9	Order	Voucher	Amount
10	100	1001	125
11	100	1003	10
12	200	1002	50
Sheet3

Cell Formulas
Range	Formula
A10:C12	A10	=LET(ov,SORT(UNIQUE(A3:B6),1),a,BYROW(ov,LAMBDA(rw,SUMIFS(C3:C6,A3:A6,INDEX(rw,1),B3:B6,INDEX(rw,2)))),HSTACK(ov,a))
Dynamic array formulas.

 

[pto160]

Absolutely fantastic. That works wonderful. The things you can do in Excel continue to amaze me. Thanks so much.

 

[Peter_SSs]

You are welcome. Thanks for the follow-up.