CODEWITHSUNDEEP
excelexcel-formula
ArnoldB
ArnoldB

Reputation: 165

Excel Countifs variable does not read

When I do this with a Sumifs formula it works. But when I try with countifs connecting to a list of names I have and want it to read it does not work. What am I missing from the formula? The Sheet1!$E$6:$E$15 is where the list of names are located I want to look and count for specifically.

{=COUNTIFS(ROOM,'Attendance Output'!B10,SERIES,Sheet1!$E$6:$E$15)}

Upvotes: 1

Views: 32

Answers (1)

user4039065
user4039065

Reputation:

It looks like you want a count for when the named range ROOM is equal to 'Attendance Output'!B10 and the named range SERIES is any of the values in Sheet1!$E$6:$E$15.

As an array/CSE formula,

=SUM(COUNTIFS(ROOM, 'Attendance Output'!B10, SERIES, Sheet1!$E$6:$E$15))

Upvotes: 1

Related Questions