Sumproduct with offset?

  • Thread starter Thread starter MJ
  • Start date Start date
M

MJ

Hello everyone,

I have a large data where I need to sum certain values based on the
criteria various rows above or below. For example, I need to sum the
values of C one row down the criteria, A=1 and B=1 (sum of 6 and 5 in
column C).

A B C
2 3 2
1 1 3
4 3 6
1 1 4
2 5 5

I have tried to combine sumproduct with the offset function, but I just
can't get it to work. Thanks.

-matt
 
Hi MJ

How about
=SUMPRODUCT(--(A1:A5=1),--(B1:B5=1),C2:C6)

Cheers
JulieD
 
Hi Matt

just needed a touch of "lateral" thinking :) - glad it solved your problem

Cheers
JulieD
 
You must log in or register to reply here.

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

Scrabble Value calculation for Welsh words 0
sumproduct with multiple variables 8
What is the "--" (double dash) in MS Excel formula? 2
sum by rows in Pivot 1
Sumproduct? 3
Sumproduct Help! 2
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Multiple Criteria Sum 8

Back
Top