Try, in any cell other than in col C, say in D2:
=SUMIF(C:C,TRUE,OFFSET(C1,ROWS($1:1)*7,))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Elaine" wrote:
I would like to use each true criteria range result as a reference to find
the cell contents to sum. i.e.True Criteria range result found in C10, Add
contents found in cell C17. The cell resulting in "true" from the criteria
will be 7 cells above the amount required for SUM ? Can I reference the
results of the criteria range and criteria formula as a base location to find
the cell with the amount to be summed ?