CODEWITHSUNDEEP
excelexcel-formula
Brendan Berkowitz
Brendan Berkowitz

Reputation: 29

Excel Countifs with offset function

I currently have a data set where I am using countifs and offset to change the column reference as I pull down the formula.

Here is my formula: 

=COUNTIFS('Student Survey (Middle)'!B:B,'Middle Master'!A2,OFFSET('Student Survey (Middle)'!G:G,0,ROW()-4,1240,1),"agree")

any idea why this is returning #Value?

Upvotes: 1

Views: 1478

Answers (1)

Scott Craner
Scott Craner

Reputation: 152535

I would get rid of the volatile OFFSET and use:

=COUNTIFS('Student Survey (Middle)'!B:B,'Middle Master'!A2,INDEX('Student Survey (Middle)'!G:XCC,0,ROW()-3),"agree")

Upvotes: 1

Related Questions