Can you add multiple arrays to the REDUCE function?

[pto160]

I was watching a great MrExcel video called PRODUCTIF With MAP REDUCE or SCAN - 2416. This was from two years ago, so things might have changed. These functions were in beta then.
He mentions that with MAP you can pass multiple arrays. He wasn't able to do that with the REDUCE function. He says it is maybe due to the optional initial value.
Is it possible to pass multiple arrays with the REDUCE function?

 

[pto160]

I was reading that it is a good ideal to provide sample data to get your question answered.
Is it possible to use the REDUCE function for this data set without using offset? The answer is 3,780.

Latest Excel_09-14-2023.xlsx
	A	B	C	D
3	Name	Values
4	Andy	2		#NAME?
5	Barb	1
6	Chris	1
7	Chris	1
8	Andy	2
9	Chris	1
10	Chris	1
11	Chris	1
12	Andy	3
13	Chris	1
14	Andy	5
15	Barb	1
16	Chris	1
17	Chris	1
18	Chris	1
19	Chris	1
20	Barb	1
21	Barb	1
22	Chris	1
23	Andy	7
24	Chris	1
25	Andy	9
Sheet4

Cell Formulas
Range	Formula
D4	D4	=reduce(1,B4:B24,lamda(total,B,IF(OFFSET(B,0,-1,1,1)="Andy",total*B,total)))

 

[StephenCrump]

Try D4: =REDUCE(1,IF(A4:A25="Andy",B4:B25,1),LAMBDA(a,b,a*b))

Or more simply: =PRODUCT(FILTER(B4:B25,A4:A25="Andy"))

 

[pto160]

That works fantastic. Thank you so much. This really helped me understand how to use a PRODUCT if.

 

[Rick Rothstein]

Or more simply: =PRODUCT(FILTER(B4:B25,A4:A25="Andy"))

Another simple formula using PRODUCT...

=PRODUCT(IF(A4:A25="Andy",B4:B25,1))

 

[pto160]

Thank you so much Rick Rothstein. That formula works great.
StephenCrump, RIck Rothstein, what is the use of the REDUCE function? Can it replace other functions?

Stephen Crump, your formula

=REDUCE(1,IF(A4:A25="Andy",B4:B25,1),LAMBDA(a,b,a*b))

Is there two arrays being passed?

 

[Rick Rothstein]

If you have done any programming, REDUCE is **kind of** the formula equivalent of a FOR EACH loop. In essence, it allows you to process each element of the array passed into the second argument one at a time. The equivalency is not perfect because there are some restrictions on how you can process the elements, but that is the underlying idea behind the REDUCE function.

 

[pto160]

Rick Rothstein, thank you for the information on the REDUCE function.