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?
|