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