I have worked a way around the problem but it is not very elegant as I need to use it many times.
I have a countifs statement that works well but I have an additional selection box which holds a list of years. All I would like is if the box says "All" then to not include it in the countifs statement, however if it says a year such as "2012" to use that in the countifs statement. Tis is what I have currently got:
=IF(J3="All",
COUNTIFS(Results[First Set Winner],"W",Results[Best of],INDIRECT("J2")),
COUNTIFS(Results[First Set Winner],"W",Results[Best of],INDIRECT("J2"),Results[Year],INDIRECT("J3")))
Thanks
Bookmarks