Forum Discussion
Formula Help
I need a formula that will return a value with multiple criteria. If P1 is found in column G then from G? return the value in the cell 3 right and 21 down from G? Attached workbook with example.
I created a Lambda called 'TotalPoints' to obtain the totals. There's a bit of moving heaven and earth because of the data arrangement but here it is:
=LAMBDA(Points_Array,Week_array,OP,month,LET(
F, FILTER(
Points_Array,
(arrOPID = OP) * (TEXT(Week_array, "mmmm") = month) * (IFERROR(YEAR(Week_array), 0) = 2023)
),
IFERROR(SUM(F), 0)
))
arrOPID was created to run parallel with the defined items to identify the rows:
=SCAN("", OPID, LAMBDA(a, v, IF(OR(v < 100, ISTEXT(v)), a, v
- When I applied this to my file, I could not get it to work.
