SUMPRODUCT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The following formula in cell I8 produces the correct result for the single
cell (I12):
=PRODUCT(I12,VLOOKUP(OFFSET(I12,0,-8),'Customer Quote'!$A$16:$G$65,7))
However, I would like to enhance this formula to sum the results of the
PRODUCT of every cell within the range I12:I50. I suspect that it may be an
array formula but cannot see the solution.
Can anybody help me please?
 
Ron,

VLOOKUP is not array formula "friendly", so your best bet is to copy the formula down to match your
range, and SUM the formulas.

HTH,
Bernie
MS Excel MVP
 
Thanks Bernie I suspected as much!


Bernie Deitrick said:
Ron,

VLOOKUP is not array formula "friendly", so your best bet is to copy the formula down to match your
range, and SUM the formulas.

HTH,
Bernie
MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with complicated formula 10
INDEX return multiple columns 1
How to make SUMPRODUCT work over range that includes text? 4
SUMPRODUCT to substiute array formula 7
Sumproduct formula problems 2
SumProduct help 3
Sumproduct syntax question 6
SUMPRODUCT Help 2

Back
Top