Sumproduct with offset?

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
 
J

JulieD

Hi Matt

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

Cheers
JulieD
 

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

Tricky one 1
What is the "--" (double dash) in MS Excel formula? 2
Creating Different Headers in Word 0
Sumproduct? 3
Sum of Variable Cells in a fixed Row 3
Sumproduct Help! 3
Finding the right style field in VBA 0
sumproduct with multiple variables 10

Top