LinkBack URL
About LinkBacks
hi guys
see attached
im looking to count how many times something happens depending on cell J6 if J6 is in column C
AND if they have won by 2 or more goals
Ive used the example Brentford
thanks in advance
hi guys
see attached
im looking to count how many times something happens depending on cell J6 if J6 is in column C
AND if they have won by 2 or more goals
Ive used the example Brentford
thanks in advance
How about with using a help cell in G2 copied down >> =IF(E2-F2>1,"Good","")
Then use in L6 >> =COUNTIFS(C:C,J6,G:G,"Good")
If you don't want to use a helper cell, then maybe >> =SUMPRODUCT(--($C$2:$C$503=J6),--($E$2:$E$503-$F$2:$F$503>1))
HTH
Regards, Jeff
Hi Jeff
Didnt want a helper column
the sumproduct formula is perfect
Thank you very much
much appreciated
You are very welcome and thanks for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
How aboutFormula:
Please Login or Register to view this content.
I'm way too slow
Hi Fluff
Still appreciate the response
thanks very much
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks