I have attached an excel sheet that includes a schedule. I am trying to count the number of game each team plays at a specific venue but the countifs statement on M2 does not work. It returns a #VALUE.
Any help would be appreciated.
Mark
I have attached an excel sheet that includes a schedule. I am trying to count the number of game each team plays at a specific venue but the countifs statement on M2 does not work. It returns a #VALUE.
Any help would be appreciated.
Mark
try:
orFormula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
-----
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
Each additional range must have the same number of rows and columns as the criteria_range1 argument. The ranges do not have to be adjacent to each other.
Last edited by sandy666; 05-04-2017 at 03:03 PM.
Works Great! Thanks so much.
You are welcome
If that takes care of your original question, read dancing text in my footnote (here or above). Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks