Search Results
6/25/2025, 3:52:04 PM
about 55% of peeps did not play mexico which is predominantly because of not wanting partial content as well as a lack of interest
here's how to do it
grab column D
copy it to a new worksheet
input this formula in B, and A is the dataset for "why did you not play mexico"
=ISBLANK(A2)
copy it down the whole way by dragging
then
=COUNTIF(B2:B587, TRUE), outputs 264 blank (ie, played Mexico)
And on another cell
=COUNTIF(B2:B587,FALSE), outputs 322 blank (ie did not play Mexico)
sum both of these up, it should give 586
here's how to do it
grab column D
copy it to a new worksheet
input this formula in B, and A is the dataset for "why did you not play mexico"
=ISBLANK(A2)
copy it down the whole way by dragging
then
=COUNTIF(B2:B587, TRUE), outputs 264 blank (ie, played Mexico)
And on another cell
=COUNTIF(B2:B587,FALSE), outputs 322 blank (ie did not play Mexico)
sum both of these up, it should give 586
Page 1