Please see the data below:


What I want to do is to write a formula in column D to sum up the order quantity (column C) starting from the row number specified in column F until current row, for the same item number.

However, when I use the address function nested in the SUMIF function, it gives an error (if I replace the address function with a value then it works).

So can someone please kindly advise me how I should write the formula in column D instead?

  • Please mark the answer given as best answered. This way, all future visitor can benefit.
    – Jacob Jan
    Oct 28, 2013 at 6:32

1 Answer 1


The problem is that address returns a string, so you need to turn that string into a reference.

Try this:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.