SOLVED

How to write the formula for this cell?

Copper Contributor
Under "score 1" I want it to tally up the cells under "bettor" that have values >0 where the corresponding cells under "fight" have the number 1 and the one under "odds" are also >0. Any ideas? Thanks
4 Replies
best response confirmed by juntjoo (Copper Contributor)
Solution

@juntjoo 

=SUMPRODUCT((ISNUMBER(SEARCH("1",A4:A7)))*(B4:B7>0)*(C4:C7>0))

 

I suggest above formula.

Thanks so much!
Is there a way to make the "fight" and "odds" columns in the formula absolute so when I paste the formula under new bettors they remain? Thanks
Oh never mind. Dumb question. Same method as you use for single cell references. Got it
1 best response

Accepted Solutions
best response confirmed by juntjoo (Copper Contributor)
Solution

@juntjoo 

=SUMPRODUCT((ISNUMBER(SEARCH("1",A4:A7)))*(B4:B7>0)*(C4:C7>0))

 

I suggest above formula.

View solution in original post