I thought Sumproduct would be correct for retrieving the correct information:

I am trying to have 2 different conditions filled and then sum'd
1st condition is to search for the number 1, 2, or 3 in a set of 5 cells in
a row (there are 297 rows)
2nd condition is to search for the letter R in the same row in one certain
cell.
If both conditions are met than I want those rows to be summed.

Formula I used was
=SUMPRODUCT(--('Proof-Press'!I3:M3300),--('Proof-Press'!O3:O330="R"))

all I get in return is !### error.. any help?

Sum product needs to have the same size arrays in each condition
try
=SUMPRODUCT(--('Proof-Press'!I3:I330+'Proof-Press'!j3:j330+'Proof-Press'!K3:K330+'Proof-Press'!L3:L330+'Proof-Press'!M3:M3300),--('Proof-Press'!O3:O330="R"))



"Murph" wrote:

I thought Sumproduct would be correct for retrieving the correct information:

I am trying to have 2 different conditions filled and then sum'd
1st condition is to search for the number 1, 2, or 3 in a set of 5 cells in
a row (there are 297 rows)
2nd condition is to search for the letter R in the same row in one certain
cell.
If both conditions are met than I want those rows to be summed.

Formula I used was
=SUMPRODUCT(--('Proof-Press'!I3:M3300),--('Proof-Press'!O3:O330="R"))

all I get in return is !### error.. any help?

I meant to add
or
=sumproduct(--(sum(offset('Proof-Press'!I3:I330,0,0,1,5)0),),--('Proof-Press'!O3:O330="R"))


"bj" wrote:

Sum product needs to have the same size arrays in each condition
try
=SUMPRODUCT(--('Proof-Press'!I3:I330+'Proof-Press'!j3:j330+'Proof-Press'!K3:K330+'Proof-Press'!L3:L330+'Proof-Press'!M3:M3300),--('Proof-Press'!O3:O330="R"))



"Murph" wrote:

I thought Sumproduct would be correct for retrieving the correct information:

I am trying to have 2 different conditions filled and then sum'd
1st condition is to search for the number 1, 2, or 3 in a set of 5 cells in
a row (there are 297 rows)
2nd condition is to search for the letter R in the same row in one certain
cell.
If both conditions are met than I want those rows to be summed.

Formula I used was
=SUMPRODUCT(--('Proof-Press'!I3:M3300),--('Proof-Press'!O3:O330="R"))

all I get in return is !### error.. any help?