CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
TheGunner4
TheGunner4

Reputation: 61

Poisson for 2 conditions in Google Sheets

Now in cell G2 the formula counts the Poisson distribution for two teams (highlighted in green and orange). How can I make the Poisson distribution in the formula count for Barcelona in the rows where there is an "H" next to the score, and for Real Madrid in the rows where there is an "A"? https://docs.google.com/spreadsheets/d/13LTLg9MvBcwGyNr1kvSMw-OjG-0FMBvP8-rORSjNQAk/edit#gid=0

=ARRAYFORMULA( POISSON.DIST(G1,AVERAGE({B3:B,E3:E}),1))

enter image description here

Upvotes: 0

Views: 44

Answers (1)

rockinfreakshow
rockinfreakshow

Reputation: 30240

You may try:

=poisson(G1,average(ifna({filter(B3:B,A3:A="H");filter(E3:E,D3:D="A")})),1)

Upvotes: 1

Related Questions