### Categories

### Links

Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

I am a human

Lets get this started

in Exercise 1 for this question

sum of items transported to NY, Baltimore and Philadelphia:

This gives me correct answer

=sum(sumif(G2:G25,{“NY”,”Boston”,”Philadelphia”),E2:E25))

But I want to learn what is wrong in the following approach as it returns 0

=SUMIFS(E2:E25,G2:G25,”NY”,G2:G25,”Boston”,G2:G25,”Philadelphia”)

I am into sport and do advance scheduling, with budgets, logistics plans.

Thanks.

Looking forward to learning.

Is there any way to unprotect theeating diary workbook I’ve been working on? I have added a bunch of new columns which show up in the statistic’s pivot table fields, but they are grayed out and not included in the table and totals. It may be a problem with the workbook being protected or could be a problem with formulas, although the columns and entry amounts show up in the eating diary. I’d appreciate help with this.

why can’t I use the templates I just paid for?

Oops! Sorry, Did not realize a comment was required. Thought that the stuff above was proof of humanity. I did enter the correct CAPTCHA crap. I hate technology.

Would like to use this for strat-o-matic baseball league with my grandsons.

YES

I am not sure what you want here. I would like to use thw excel templates

human

Hi

Excellent sports tournament spread sheet.

I have doctored it slightly so all the Tables appear on 1 sheet for printing purposes.

As we have a different scoring system could you please let me have the password for the option sheet.

Thx

Geoff

Thank you for sharing your knowledge with us. In one reply messages you said that you will provide us password for option sheet if we signup. So I signup, thanks.

I am a human

looking to document our bowling club championships

Thinking of setting up a tournament (football/Soccer UK) for next June 2019 with either 8 or 10 teams invited, either size would have two groups of 4 or 5 teams playing each other one in group stages listing in league showing, then going into knockout stages with higher teams in each group playing for Cup and lower teams playing for Shield , do you have something already set up in a template for this ?

kind regards

Keith

Great site for excel inservice. We will have a interschool sports carnival in two weeks time. The sports are Soccer, Touch Footy, Volleyball, Basketball (boys and girls ), netball (girls only) and Athletics (girls and boys).

The point system for all sport will be the Medal Tally Point System. 1st place – Gold, 2nd place – Silver and 3rd place – Bronze.

The school with the highest number of Gold should be the winner.

As such I need assistance for a template. Thank you

I like the spreadsheet and have opt for the 10 team double robin. I’m hosting a table tennis tournament where each team hold 3 players. I would like to record the data under the team A for each player vs team B player. So it’s A: 3 players vs B: 3 players and one set of doubles. Ten point system (Team A vs Team B 6:4) Matches are played best-out-of 5.

Hi, I was wondering if I made a donation, if you could change a few things for how wins and losses are calculated for a league I run. if you are interested, please email me when you get a chance

I want to pratice

Hi,

I have a tournament coming up where there are 10 teams playing 9 rounds. As the top 5 teams are somewhat more proficient than the 6 to 10 teams, is it possible to structure the XL spreadsheet draw that when the top 5 teams play the bottom 5, the top 5 automatically have an 8 point handicap but when the top 5 play against the other top 5 teams it’s even Stevens??

Cheers

Can you please make template for cricket points table

Thanks

Hi. I Need format for 16 teams- Group A, B, C, and D – 4 TEAMS IN EACH-

2 ADVANCE FROM EACH GROUP FOR QUATER, SEMIS AND THAN FINAL.

please help me.

How to see the result formula

I am a human

Good morning

I downloaded a file so I can play a tournament with my young students. I cannot save the file because it needs a password. Do you give out the Passwords? If yes… could you please send me the Password to the Excel file? I have a very small class of six kids with special needs.

greets from Switzerland

Karl von Arb

Test

Please

Please let me sign in for my hobby.

12 TEAMS PLAYING EACH WEEK.

3 TEAMS PLAY EACH OTHER, A V B, A V C, B V C.

ON 1 PITCH OVER 1 HOUR

20 MINUTES EACH GAME.

TEMPLATE FOR 12 TEAM HOME AND AWAY.

This is Great

How may I get further assistance from you on time?

47CYBU

Hello,

I am inquiring about the tournament spreadsheet, which is great and sort of what I am looking for. I am part of a football league and would like to be able to create a schedule for our parks. I like your spreadsheet but I would like to modify it for an “X” number of teams (more then 15) for a 10 game season with 10 fields per week (each park has their own field). It would also need to have 5 home games for each parks. I was wondering if it would be possible for you and me to collaborate on this. I have something already created but it is all manual and it requires a lot of review to ensure we do not have duplicate games or schedule a 2 teams to play at home on the same day who play against each other.

Hello,

I’m glad you like my spreadsheets 🙂 Unfortunately I can’t help you. I left the world of Microsoft and now I’m focusing on Linux.

Jan

Hello Sir,

Good day to you.

I have to make football league table for 20 teams, round robin (home & away) and 4 fields in 6/7 weeks matchday. Can you help me with that.

Thank you, Sir.

Hi Your table is great I look after a Lawn Bowling League which scores a bit differently to football our league is based upon the following ranking

1. Number of points

2. The difference between shots for and against

I am not able to adjust your table maybe you can help me please

Sports tournament is a great excel template.

And I want to use him for our billiards club.

Now I need to make some chances to the sheet.

I hope I can explain it well.

Each player has a maximum score, we call it moyenne.

If a player wins a match, he will get 2 points.

He also get his moyenne he receives 1 point. He receives a total of 3 points.

If a player has lost, but he gets his moyenne he get 1 point.

At a draw both players get 1 point. And also, both players have their moyenne, both player get 1 point.

{= IF ((home = W4) * (home score> = moyenne), 1, 0)}

Sports tournament is a great excel template.

And I want to use him for our billiards club.

Now I need to make some adjustments to the sheet.

I hope I can explain it well.

Each player has a maximum score, we call it average.

If a player wins a match, he will get 2 points.

He also won his moyenne he receives 1 point. He receives a total of 3 points.

If a player has lost, but he gets his moyenne get 1 point.

At a draw both players get 1 point. And here too, both players have their moyenne get both player 1 point.

{= IF ((home = W4) * (home score> = moyenne), 1, 0)}

One day tournament, lets hope this works

Malhi

mil gracias por compartir su trabajo….

Hi there I will be running a one day tournament, so may need some assistance with points etc and how it all works. Entries do close end of the week so I will be able to tell you then.

Thanks

Very nice site!

Very nice site!

Very nice site!

It is also possible that Zynga’s chosen advertising network is to blame if we consider the case of the New York Times’ website efdfgceebbbe

hi fantastic site,

im bowls fixtures sec and i use this ten team template which is great thanks, but we play each other twice home and away, please could you tell me how to get the template to work for home and away

regards colin

Hi

We have a tournament with the following format can not figure out formula for this. We need two separate tables for the pools because the top two teams from each pool play in the semi finals with the 3rd team in each pool eliminated

2 POOLS WITH THREE TEAMS IN EACH POOL

ALL TEAMS PLAY EVERY OTHER TEAM IN THEIR POOL ONCE PLUS ONE TEAM FROM THE OTHER POOL.

GREAT SITE

Thanks a lot for the vast info/knowledge one could benefit from your website.