Hi All,
I've worked this out in the past - but seem to be having a brain fade ;-(
I have a number of competitors, each will complete a different number of rounds each time they participate
eg Mark will do 2 rounds this week, only 1 next week etc
I want to get a total of how many rounds (indicated by a score .. including possibly zero) each person has played.
Desired results are in yellow highlight
Hope that makes sense
Thanks in Advance.
Mark
Last edited by mbender; 07-14-2021 at 03:29 AM.
Did you get half of your expected answers incorrect?? Mark = 3, surely...
=SUMPRODUCT(($A$4:$A$8=F4)*($B$4:$D$8>0))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
thanks Glenn
I've uploaded a revised file
the zeros count as a score, So Mark should be 5
so <>"" to replace >0 has me all sorted
thanks a lot
Mark
Then use:
=SUMPRODUCT(($A$4:$A$8=F4)*($B$4:$D$8<>""))
sorry - posts collided on the way through ;-)
Have a good one.
You're welcome & thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks