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?