Countif formula help
I have a spreadsheet designed for softball schedule for an entire league and am trying to come up with a way to count certain information so that I can figure out if the schedule is balanced.
I have attached this sheet for anyone wishing to help.
What I'd like is for a way to sum the number of games each team plays on diamond 3 or 4 and to sum number of games at 6:30/7:30/8:30
THANK YOU
Last edited by tryder; 07-02-2009 at 02:05 AM.
Nothing too fancy in there, just some countifs.
I think it's got what you're looking for
added in a row for ease of reference, to use two formulas to count everything instead of 5. Placing constants in the right spot allows you to cut down on tweaking.
let me know how it looks.
mew!
Last edited by mewingkitty; 07-02-2009 at 01:59 AM.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Re: Countif formula help
Thanks exactly what I was looking for!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks