sumproduct based on relative cell Solved/Closed

Question

Hello, 

I can use sumproduct based on information contained in the same range of rows of a column adjacent to it, but I can't figure out how to do a variation of this:


How would I sumproduct based on text contained in another row and column.. (two columns to the right and four rows up of the cell to be summed)

Mazzaropi · Answer

Brian, Good afternoon.

No problems.

BUT...the range MUST have same size.

eg.: =SUMPRODUCT((A1:A10="a")*(C31:C40>35)*(X1044:X1053))

ALL of them have 10 CELLS. 

Is that what you're looking for?
I hope it helps.
 --
Belo Horizonte, Brasil.
Marcílio Lobão

BrianP · Answer

Above is an example.
With sumproduct I can sum up the two amounts for Central Auto Parts and JS Safety,based on the "Dollar Amount" text entry in column A.
I want to add another condition however, which is that column D has an "MBE" entry, but it's a cell entry two columns to the right and 4 rows up relative to each dollar amount

Sumproduct based on relative cell

2 responses

Similar discussions

Subscribe To Our Newsletter!