Using Indirect in Sumif

I am trying to modify a SumIf using "Indirect" to return the the sum of data  that is two rows above the criteria for the sum.   I just can't seem to get it to work.

Sample data attached
Who is Participating?
mankowitzConnect With a Mentor Commented:
I'm not sure you want INDIRECT here which returns the values in a range when an address (i.e. "A1:A2") is specified.

Why don't you offset the second reference by two rows, like this


Note that the F column starts at F3, while the D column starts at D1
MacroShadowConnect With a Mentor Commented:
Enclose the range in double quotes, i.e.

Open in new window

uadAuthor Commented:
Had to split the points, because both solutions worked.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.