 SBR Top-Rated Sportsbooks |
Best Sportsbooks List
|
|
| |||||
| #1 FanDuel | SBR rating 4.8/5 | Review | #6 BetRivers | SBR rating 4.1/5 | Review | #2 Caesars | SBR rating 4.7/5 | Review | #7 Fanatics | SBR rating 4.1/5 | Review |
| #3 DraftKings | SBR rating 4.7/5 | Review | #8 Betway | SBR rating 3.8/5 | Review | ||
| #4 BetMGM | SBR rating 4.6/5 | Review | #9 Borgata | SBR rating 3.5/5 | Review | ||
| #5 bet365 | SBR rating 4.6/5 | Review | #10 ClutchBet | SBR rating 2.9/5 | Review | ||
don't excel very well :(
hi any of u excellent excel-ers know how to fix this please?
=COUNTIFS(F2=M$2$,(L2,"=true"))
just want a count if both things are true:
countif(F2=M$2$)
countif(L2,"=true")
then i want to be able to drag this down like 60 rows.
sorry for the stupidness but it annoying me now... man WR to betting, i wish i was born 10 years earlier or 10 years later grrrr.
easiest 50 points u ever made?
many thanks
Last edited by subs; 01-27-11 at 08:31 PM. Reason: don't spell very well either
COUNTIFS function isn't supported until office 2007. This should work for all versions:
=IF(COUNTIF(F2,$M$2)+COUNTIF(L2,"=true")=2,1,"")
If both conditions are true this will return a value of 1, otherwise cell will be left blank.
GL
|
|
hi josie88 thanks for the help.
was not really the answer i was looking for because it only returned 1 or blank. i needed a total. but close. actually i screwed up the question, the answer is:
=COUNTIFS(L:L,"=TRUE",F:F,M2) so simple i can't believe it has taken me so long to do it....
thanks for ur help : )
subs gave josie88 25 SBR Point(s) for this post.