SUMIFS(my_mentalstate;crazy) =100%

[K12345]

Im trying to make this SUMIFS function work:

=SUMIFS('Action Tracking'!$E$9:$E$122;'Action Tracking'!$H$9:$H$122;'Specify Name'!$F$6:$F$51;'Action Tracking'!$C$9:$C$122;'Day 1 Summary'!C6;'Action Tracking'!$O$9:$O$122;"Day 1")

Where 'Specify Name'!$F$6:$F$51, equals a list of about 50 possible names.

I want the function to work so that the user can choose who to see the activities for, so they can see it for e.g. just themselves, or 10 of their team members etc.

However, the function only uses one name at a time as that criteria ('Specify Name'!F6).

How can I get it to consider the whole list of names, and not just one at a time?


Ive also tried naming the range (list), but it stays the same.

Thank you in advance!

Katharina

[dilipandey]

Hi Katharina,

welcome to the forum.

Please upload a sample workbook.. or let me know if I post a sample, you are happy to replicate that in your workbook

Regards,
DILIPandey

<click on below 'star' if this helps>

[JosephP]

try
=SUMPRODUCT(SUMIFS('Action Tracking'!$E$9:$E$122;'Action Tracking'!$H$9:$H$122;'Specify Name'!$F$6:$F$51;'Action Tracking'!$C$9:$C$122;'Day 1 Summary'!C6;'Action Tracking'!$O$9:$O$122;"Day 1"))

[K12345]

Thank you to both of you!

Joseph, it still does not return the right numbers..

DILIPandey, Ill upload a sample in one second.

[dilipandey]

Hi Katharina,

I am not able to find the sheets Action Tracking, specify name extra in the workbook you uploaded.. please check. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[JosephP]

the only reason I can see that the sumproduct formula wouldn't work is that you have repeated one of the names (Name1) in the list on sheet2. if they are unique the totals are correct