[SOLVED] Using SUMIFS with MAP/LAMBDA

Using SUMIFS with MAP/LAMBDA

I'm fairly new to MAP/LAMBDA formulas and I can't seem to figure this one out. I would like to keep it a MAP/LAMBDA formula as the size of the table can change and I don't want to have to copy down the formula when it does.

Here is what the data looks like:

	Checkbox 1	Checkbox 2	Checkbox 3
Leader	Status1	Status2	Status3	Total
Tim Cook	1	10	6	FORMULA HERE
Steve Jobs	4	13	10

My goal is to add up the numbers if the checkbox is checked. Let's say I want Status 1 and Status 3 added, I would have Checkbox 1 and Checkbox 3 checked.

Here is my attempt at the formula:

=MAP($A3:$A,LAMBDA(x,IF(x="","",SUMIFS(B3:D3,$B$1:$D$1,true))))

What am I doing wrong here?

The intended outcome should be:

	Checkbox 1 = TRUE	Checkbox 2 = FALSE	Checkbox 3 = TRUE
Leader	Status1	Status2	Status3	Total
Tim Cook	1	10	6	7
Steve Jobs	4	13	10	14

Here is a sample sheet (Question 1).

Solution

You may try:

=byrow(filter(B3:D,B1:D1),lambda(Σ,if(counta(Σ)=0,,sum(Σ))))