Cell Indirect Reference Question

Greetings, List!

I have a cell indirect reference question.  I want to sum each instance
in a column of numbers where the same row has a certain value in a
different column.  After combing the list and the docs, I constructed
this formula:


However, I have one more requirement.  :-)  I want to utilize the
contents of another cell to determine the end of the set of rows in the
SUMIF.  IOW, I want something like this:


where G3 contains the value of the last row to sum.  However, this
formula gets flagged as invalid.  I tried using the INDIRECT function
like so:


but that also gets flagged as invalid.

Can anyone help me?



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]