Formula Array CountIf help

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

Unsolved

Post Body

I have a Gsheet that is linked to a form where the responses put a "Win", "Loss",or "Draw" in each column of E2:G. The Win/loss/draw will only ever show up in the row in columns E:G.

I am trying to do a formula array to count the number of wins for each row and put that number in Column "I" So far I haven't had much luck getting it to work. Below are a few of my attempts:

Returned 0 in I2

=ARRAYFORMULA(COUNTIFS(ROW(E2:E),"WIN"))

This one put the total number of wins in I2

=ARRAYFORMULA(countifS(E2:G,"Win"))

This one put the total number of wins in I2

=ArrayFormula(SUM(countif(E2:E,"WIN") COUNTIF(F2:F,"WIN") SUM(G2:G,"WIN")))

Author

Account Strength

100%

Account Age

8 years

Verified Email

Yes

Verified Flair

Total Karma

30,963

Link Karma

3,014

Comment Karma

27,901

Profile updated: 2 days ago

Posts updated: 1 week ago

trixster87

Subreddit

r/spreadsheets

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 5 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/spreadsheet...