Search ranges, identify column and sumif

[vikosh]

Hi,

I am trying to find a solution to the following.

I need to search ranges (3 ranges as per below example), identify last column that has 1's in it and then do sumif according to the names.
Splitting rows can have any random information, and might be even merged, so i need to set ranges.

A	B	C	D	E	F	G
	1	2	3	4	5	6
name 1	1	0	0	0	0	0
name 2	1	1	1	0	0	0
name 3	1	1	1	1	0	0
name 2	1	1	0	0	0	0
name 1	1	1	1	0	0	0
name 2	1	0	0	0	0	0
name 2	1	1	1	1	0	0
name 1	1	1	0	0	0	0
name 1	1	1	1	0	0	0
name 2	1	0	0	0	0	0
name 2	1	1	1	1	0	0
name 1	1	1	0	0	0	0

<tbody>
</tbody>

In this example sumif would return:

Name 1: 0
Name 2: 2
Name 3: 1

Please direct my thoughts in the right way...

Thank you,
Vikosh

 

[Andrew Poulsom]

Did you remember to confirm with Ctrl+Shift+Enter? Can you post some sample data where the formula isn't working? Why the reference to Lists!D2?

 

[vikosh]

I've figured it out - thanks a million.

My mistake was that in the original file array starts from Column F, so basically INDEX was getting the wrong column. I've just added -5 to *(COLUMN(F$7:AJ$7)-5))))) and it fixed it.

Thank you one more time.