Sumproduct.......

  • Thread starter Thread starter Kstalker
  • Start date Start date
K

Kstalker

I have a problem surrounding sumproduct and setting criteria.

I need to sumproduct based on row criteria '19:19'. The value for the
row criteria is set in an other cell 'E23'.

So sum of row 9 and row 17 where 19 is equal to E23.


=SUMPRODUCT((OFFSET(A9,,MATCH(E23,19:19,0)-1,(OFFSET(A17,,MATCH(E23,19:19,0)+1)/1))))


Any help greatly appreciated
 

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

Sumproduct................. 8
SumProduct #value error 1
New to SUMPRODUCT .. is there a better way? 1
Formula Changed 3
Min Function not calculating correctly with further calculations 3
Sumproduct 3 Criteria 4
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Really need some help with a multi conditional SumProduct 1

Back
Top