SumProduct?

M

Murph

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:M330>0),--('Proof-Press'!O3:O330="R"))

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

bj

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:M330>0),--('Proof-Press'!O3:O330="R"))
 
B

bj

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

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

Top