Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi Again, Hers the formula that does what I want.
What formula would combine the club selection and the GW.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 37%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWA%3C/text%3E%3C/svg%3E)
William Auld
60
Reputation points
I want to see what a team stats are in a given GW. I've tried to use +and * added unto the FILTER code but that doesnt work.
Microsoft 365 and Office | Excel | For home | Windows
3 answers
Sort by: Most helpful
-
William Auld 60 Reputation points
2026-02-13T17:23:25.61+00:00 -
riny 20,865 Reputation points Volunteer Moderator2026-02-14T06:41:38.3166667+00:00 Great! That confirms my initial comment. You merely added the third optional [if_empty] argument that suppresses the CALC error.
Sign in to comment -
-
William Auld 60 Reputation points
2026-02-13T13:34:04.9933333+00:00 Sorry Riny but as you can see that formula returns #CALC!. Thanks anyway.
-
riny 20,865 Reputation points Volunteer Moderator
2026-02-13T13:49:29.82+00:00 If you intended to upload a screenshot, I can't see it. But when FILTER returns a CALC error it means that no matches are found for both "Man Utd" and "GW12". Since you formula works for "Man Utd" only my guess is that the error occurs with "GW12". Perhaps the data contains " GW12" or "GW12 " (note the extra spaces). Or perhaps GW12 is not in column A of your data. I just guessed as you your screenshot wasn't clear.
Sign in to comment -
-
riny 20,865 Reputation points Volunteer Moderator
2026-02-13T05:43:05.46+00:00 I guess this is what you need.
=FILTER( A2:D698, (C2:C698 = F1) * (A2:A698 = M1) )Note that you need the wrap the filter criteria in parentheses in order to use + (for OR) or * (for AND).