Countifs formula

Douglas Edward

New Member
Joined
Jul 24, 2018
Messages
22
Is it possible to make this "Golf Course Count Table" (on the right) without the "Day" cheater column? and just get the info from the "Date" column?

ACADAEAFAGAHAIAJAKALAMAN
3DateDayTimeLocationTournamentPlayersCourseWednesdayFridaySaturdayTotal
4Friday, January 3, 2020Friday7amWilsonNew Year's Super Skins60Wilson26715
5Saturday, January 11, 2020Saturday7amHardingLeaning Tree Classic60Harding35614
6Wednesday, January 22, 2020Wednesday7amHarding3/6 Scramble32LA City Away0112
7Saturday, February 8, 2020Saturday7amWilsonThe Bambino60Total5121431
8Friday, February 21, 2020Friday7amWilson1457: Banned by Law60
9Begins in MarchFourball Championship96
10Saturday, March 7, 2020Saturday7amHardingThe Rogow72
11Wednesday, March 18, 2020Wednesday7amHardingSt. Patty's Shamble84
12Friday, March 27, 2020Friday7amWilsonArnie's Army60
13Saturday, April 4, 2020Saturday7amWilsonGPGC 36 Hole Championship Day 184
14Sunday, April 5, 2020Sunday7amHardingGPGC 36 Hole Championship Day 284
15Friday, April 24, 2020Friday7amHardingThe Didrikson32
16Saturday, May 2, 2020SaturdayIndian Canyons South8th Annual Palm Springs Desert Classic40
17Sunday, May 3, 2020SundayDesert Willow Firecliff8th Annual Palm Springs Desert Classic40
18Friday, May 15, 2020Friday7amHansen DamThe Dam60
19Saturday, May 30, 2020Saturday7amHardingMarty Tregnan Memorial84
20Saturday, June 20, 2020Saturday7amWilsonThe Open84
21Wednesday, June 24, 2020Wednesday7amWilsonThe International60
22Friday, July 3, 2020Friday7amHardingRed White and Blue64
23Saturday, July 11, 2020Saturday7amEncinoEncino Man84
24Saturday, August 1, 2020Saturday7amHardingSNIEGOWSKI XI84
25Wednesday, August 12, 2020Wednesday7amWilsonThe Tune-Up32
26Friday, August 21, 2020Friday7amHarding83rd Club Championship Qualifier120
27Saturday, August 22, 2020Saturday7amWilson83rd Club Championship Qualifier120
28Friday, September 4, 2020Friday7amWilsonThe Club Championship & Championship Sunday32
29Saturday, September 5, 2020Saturday7amHardingThe Club Championship & Championship Sunday16
30Sunday, September 6, 2020Sunday7amWilsonThe Club Championship & Championship Sunday60
31Saturday, September 19, 2020Saturday7amHardingFall Season Kickoff84
32Saturday, October 3, 2020Saturday7amWilsonOktoberfest32
33Friday, October 16, 2020Friday7amWilsonThe President's Cup24
34Friday, October 16, 2020Friday1pmHardingThe President's Cup24
35Saturday, October 17, 2020Saturday7amWilsonThe President's Cup24
36Friday, October 30, 2020Friday7amHardingHalloween84
37Saturday, November 14, 2020Saturday7amWilsonTurkey Shoot84
38Wednesday, November 25, 2020Wednesday7amHarding3 Club Challenge32
39Friday, December 11, 2020Friday7amWilsonChristmas Shotgun128

<tbody>
</tbody>
Sheet2

Worksheet Formulas
CellFormula
AK4=COUNTIFS(Table15[Location],AJ4,Table15[Day],Table7[[#Headers],[Wednesday]])
AL4=COUNTIFS(Table15[Location],AJ4,Table15[Day],AL3)
AM4=COUNTIFS(Table15[Location],AJ4,Table15[Day],AM3)
AN4=SUM(Table7[@[Wednesday]:[Saturday]])
AK5=COUNTIFS(Table15[Location],AJ5,Table15[Day],AK3)
AL5=COUNTIFS(Table15[Location],AJ5,Table15[Day],AL3)
AM5=COUNTIFS(Table15[Location],AJ5,Table15[Day],AM3)
AN5=SUM(Table7[@[Wednesday]:[Saturday]])
AK6=COUNTIFS(Table15[Location],AA4,Table15[Day],Table7[[#Headers],[Wednesday]])+COUNTIFS(Table15[Location],AA6,Table15[Day],Table7[[#Headers],[Wednesday]])
AL6=COUNTIFS(Table15[Location],AA4,Table15[Day],Table7[[#Headers],[Friday]])+COUNTIFS(Table15[Location],AA6,Table15[Day],Table7[[#Headers],[Friday]])
AM6=COUNTIFS(Table15[Location],AA4,Table15[Day],Table7[[#Headers],[Saturday]])+COUNTIFS(Table15[Location],AA6,Table15[Day],Table7[[#Headers],[Saturday]])
AN6=SUM(Table7[@[Wednesday]:[Saturday]])
AK7=SUM(AK4:AK6)
AL7=SUM(AL4:AL6)
AM7=SUM(AM4:AM6)
AN7=SUM(Table7[@[Wednesday]:[Saturday]])

<tbody>
</tbody>

<tbody>
</tbody>
 

Twollaston

Board Regular
Joined
May 24, 2019
Messages
223
Re: Need help with countifs formula

yes, try this

=SUMPRODUCT((IFERROR(FIND(AK$3,$AC$4:$AC$39),0)=1)*($AF$4:$AF439=$AJ4))
double click in the formula once its in cell J2 and use ctrl + Shift + enter

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: right;;">3</td><td style=";">Date</td><td style=";">Day</td><td style=";">Time</td><td style=";">Location</td><td style=";">Tournament</td><td style=";">Players</td><td style="text-align: right;;"></td><td style=";">Course</td><td style=";">Wednesday</td><td style=";">Friday</td><td style=";">Saturday</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;;">4</td><td style=";">Friday, January 3, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">New Year's Super Skins</td><td style="text-align: right;;">60</td><td style="text-align: right;;"></td><td style=";">Wilson</td><td style="text-align: right;;">2</td><td style="text-align: right;;">6</td><td style="text-align: right;;">7</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;;">5</td><td style=";">Saturday, January 11, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">Leaning Tree Classic</td><td style="text-align: right;;">60</td><td style="text-align: right;;"></td><td style=";">Harding</td><td style="text-align: right;;">3</td><td style="text-align: right;;">5</td><td style="text-align: right;;">6</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;">6</td><td style=";">Wednesday, January 22, 2020</td><td style=";">Wednesday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">3/6 Scramble</td><td style="text-align: right;;">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: right;;">7</td><td style=";">Saturday, February 8, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">The Bambino</td><td style="text-align: right;;">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: right;;">8</td><td style=";">Friday, February 21, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">1457: Banned by Law</td><td style="text-align: right;;">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: right;;">9</td><td style=";">Begins in March</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Fourball Championship</td><td style="text-align: right;;">96</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: right;;">10</td><td style=";">Saturday, March 7, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">The Rogow</td><td style="text-align: right;;">72</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: right;;">11</td><td style=";">Wednesday, March 18, 2020</td><td style=";">Wednesday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">St. Patty's Shamble</td><td style="text-align: right;;">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style="text-align: right;;">12</td><td style=";">Friday, March 27, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">Arnie's Army</td><td style="text-align: right;;">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style="text-align: right;;">13</td><td style=";">Saturday, April 4, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">GPGC 36 Hole Championship Day 1</td><td style="text-align: right;;">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style="text-align: right;;">14</td><td style=";">Sunday, April 5, 2020</td><td style=";">Sunday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">GPGC 36 Hole Championship Day 2</td><td style="text-align: right;;">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style="text-align: right;;">15</td><td style=";">Friday, April 24, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">The Didrikson</td><td style="text-align: right;;">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style="text-align: right;;">16</td><td style=";">Saturday, May 2, 2020</td><td style=";">Saturday</td><td style="text-align: right;;"></td><td style=";">Indian Canyons South</td><td style=";">8th Annual Palm Springs Desert Classic</td><td style="text-align: right;;">40</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style="text-align: right;;">17</td><td style=";">Sunday, May 3, 2020</td><td style=";">Sunday</td><td style="text-align: right;;"></td><td style=";">Desert Willow Firecliff</td><td style=";">8th Annual Palm Springs Desert Classic</td><td style="text-align: right;;">40</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style="text-align: right;;">18</td><td style=";">Friday, May 15, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Hansen Dam</td><td style=";">The Dam</td><td style="text-align: right;;">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style="text-align: right;;">19</td><td style=";">Saturday, May 30, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">Marty Tregnan Memorial</td><td style="text-align: right;;">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style="text-align: right;;">20</td><td style=";">Saturday, June 20, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">The Open</td><td style="text-align: right;;">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">19</td><td style="text-align: right;;">21</td><td style=";">Wednesday, June 24, 2020</td><td style=";">Wednesday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">The International</td><td style="text-align: right;;">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">20</td><td style="text-align: right;;">22</td><td style=";">Friday, July 3, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">Red White and Blue</td><td style="text-align: right;;">64</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">21</td><td style="text-align: right;;">23</td><td style=";">Saturday, July 11, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Encino</td><td style=";">Encino Man</td><td style="text-align: right;;">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">22</td><td style="text-align: right;;">24</td><td style=";">Saturday, August 1, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">SNIEGOWSKI XI</td><td style="text-align: right;;">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">23</td><td style="text-align: right;;">25</td><td style=";">Wednesday, August 12, 2020</td><td style=";">Wednesday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">The Tune-Up</td><td style="text-align: right;;">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">24</td><td style="text-align: right;;">26</td><td style=";">Friday, August 21, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">83rd Club Championship Qualifier</td><td style="text-align: right;;">120</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">25</td><td style="text-align: right;;">27</td><td style=";">Saturday, August 22, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">83rd Club Championship Qualifier</td><td style="text-align: right;;">120</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">26</td><td style="text-align: right;;">28</td><td style=";">Friday, September 4, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">The Club Championship & Championship Sunday</td><td style="text-align: right;;">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">27</td><td style="text-align: right;;">29</td><td style=";">Saturday, September 5, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">The Club Championship & Championship Sunday</td><td style="text-align: right;;">16</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">28</td><td style="text-align: right;;">30</td><td style=";">Sunday, September 6, 2020</td><td style=";">Sunday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">The Club Championship & Championship Sunday</td><td style="text-align: right;;">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">29</td><td style="text-align: right;;">31</td><td style=";">Saturday, September 19, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">Fall Season Kickoff</td><td style="text-align: right;;">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">30</td><td style="text-align: right;;">32</td><td style=";">Saturday, October 3, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">Oktoberfest</td><td style="text-align: right;;">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">31</td><td style="text-align: right;;">33</td><td style=";">Friday, October 16, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">The President's Cup</td><td style="text-align: right;;">24</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">32</td><td style="text-align: right;;">34</td><td style=";">Friday, October 16, 2020</td><td style=";">Friday</td><td style=";">1pm</td><td style=";">Harding</td><td style=";">The President's Cup</td><td style="text-align: right;;">24</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">33</td><td style="text-align: right;;">35</td><td style=";">Saturday, October 17, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">The President's Cup</td><td style="text-align: right;;">24</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">34</td><td style="text-align: right;;">36</td><td style=";">Friday, October 30, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">Halloween</td><td style="text-align: right;;">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">35</td><td style="text-align: right;;">37</td><td style=";">Saturday, November 14, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">Turkey Shoot</td><td style="text-align: right;;">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">36</td><td style="text-align: right;;">38</td><td style=";">Wednesday, November 25, 2020</td><td style=";">Wednesday</td><td style=";">7am</td><td style=";">Harding</td><td style=";">3 Club Challenge</td><td style="text-align: right;;">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">37</td><td style="text-align: right;;">39</td><td style=";">Friday, December 11, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">Christmas Shotgun</td><td style="text-align: right;;">128</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J2</th><td style="text-align:left">{=SUMPRODUCT(<font color="Blue">(<font color="Red">IFERROR(<font color="Green">FIND(<font color="Purple">J$1,$B$2:$B$37</font>),0</font>)=1</font>)*(<font color="Red">$E$2:$E$37=$I2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K2</th><td style="text-align:left">{=SUMPRODUCT(<font color="Blue">(<font color="Red">IFERROR(<font color="Green">FIND(<font color="Purple">K$1,$B$2:$B$37</font>),0</font>)=1</font>)*(<font color="Red">$E$2:$E$37=$I2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L2</th><td style="text-align:left">{=SUMPRODUCT(<font color="Blue">(<font color="Red">IFERROR(<font color="Green">FIND(<font color="Purple">L$1,$B$2:$B$37</font>),0</font>)=1</font>)*(<font color="Red">$E$2:$E$37=$I2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J3</th><td style="text-align:left">{=SUMPRODUCT(<font color="Blue">(<font color="Red">IFERROR(<font color="Green">FIND(<font color="Purple">J$1,$B$2:$B$37</font>),0</font>)=1</font>)*(<font color="Red">$E$2:$E$37=$I3</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K3</th><td style="text-align:left">{=SUMPRODUCT(<font color="Blue">(<font color="Red">IFERROR(<font color="Green">FIND(<font color="Purple">K$1,$B$2:$B$37</font>),0</font>)=1</font>)*(<font color="Red">$E$2:$E$37=$I3</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L3</th><td style="text-align:left">{=SUMPRODUCT(<font color="Blue">(<font color="Red">IFERROR(<font color="Green">FIND(<font color="Purple">L$1,$B$2:$B$37</font>),0</font>)=1</font>)*(<font color="Red">$E$2:$E$37=$I3</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
 
Last edited:

Twollaston

Board Regular
Joined
May 24, 2019
Messages
223
Re: Need help with countifs formula

ps. I was guessing the number on the far left was supposed to be the row number for you. so I adjusted the top formula to reflect that
 

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,344
Office Version
365
Platform
Windows
Re: Need help with countifs formula

Here is a way using COUNTIFS.
Mine shows 0 for LA City as there were none in the data you posted. Also, I only copied back a small part of the data into the forum.
Copy the formula down and across as needed.
Excel Workbook
ACADAEAFAGAHAIAJAKALAMAN
3DateDayTimeLocationTournamentPlayersCourseWednesdayFridaySaturdayTotal
4Friday, January 3, 2020Friday7amWilsonNew Year's Super Skins60Wilson 67
5Saturday, January 11, 2020Saturday7amHardingLeaning Tree Classic60Harding356
6Wednesday, January 22, 2020Wednesday7amHarding3/6 Scramble32LA City Away000
7Saturday, February 8, 2020Saturday7amWilsonThe Bambino60Total
8Friday, February 21, 2020Friday7amWilson1457: Banned by Law60
9Begins in MarchFourball Championship96
10Saturday, March 7, 2020Saturday7amHardingThe Rogow72
Sheet
 

Douglas Edward

New Member
Joined
Jul 24, 2018
Messages
22
Re: Need help with countifs formula

I'm doing it wrong, but I don't know why. Ha I enter =SUMPRODUCT((IFERROR(FIND(J$1,$B$2:$B$37),0)=1)*($E$2:$E$37=$I2)) into cell J2, then double click the formula, then Ctrl+Shift+Enter to get the curly braces. But I'm getting a incorrect answer of 0.

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="color: #FFFFFF;background-color: #548235;;">Date </td><td style="color: #FFFFFF;background-color: #548235;;">Day</td><td style="color: #FFFFFF;background-color: #548235;;">Time</td><td style="color: #FFFFFF;background-color: #548235;;">Location</td><td style="color: #FFFFFF;background-color: #548235;;">Tournament</td><td style="color: #FFFFFF;background-color: #548235;;">Players</td><td style="text-align: right;;"></td><td style="border-right: 1px solid black;border-bottom: 1px solid black;;">Course</td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Wednesday</td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Friday</td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Saturday</td><td style="border-bottom: 1px solid black;border-left: 1px solid black;;">Total</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Friday, January 3, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">New Year's Super Skins</td><td style=";">60</td><td style="text-align: right;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #548235;;">Wilson</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #548235;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #548235;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #548235;;">0</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">Saturday, January 11, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-style: italic;;">Leaning Tree Classic</td><td style=";">60</td><td style="text-align: right;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #92D050;;">Harding</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #92D050;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #92D050;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #92D050;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">Wednesday, January 22, 2020</td><td style=";">Wednesday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">3/6 Scramble</td><td style=";">32</td><td style="text-align: right;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #F8CBAD;;">LA City Away</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #F8CBAD;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #F8CBAD;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #F8CBAD;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">Saturday, February 8, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">The Bambino</td><td style=";">60</td><td style="text-align: right;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;background-color: #D9D9D9;;">Total</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;">0</td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">Friday, February 21, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">1457: Banned by Law</td><td style=";">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">Begins in March</td><td style=";"></td><td style=";"></td><td style=";"></td><td style="font-weight: bold;;">Fourball Championship</td><td style=";">96</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">Saturday, March 7, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">The Rogow</td><td style=";">72</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">Wednesday, March 18, 2020</td><td style=";">Wednesday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">St. Patty's Shamble</td><td style=";">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">Friday, March 27, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">Arnie's Army</td><td style=";">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style=";">Saturday, April 4, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">GPGC 36 Hole Championship Day 1</td><td style=";">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style=";">Sunday, April 5, 2020</td><td style=";">Sunday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">GPGC 36 Hole Championship Day 2</td><td style=";">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style=";">Friday, April 24, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">The Didrikson</td><td style=";">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style=";">Saturday, May 2, 2020</td><td style=";">Saturday</td><td style=";"></td><td style="background-color: #B4C6E7;;">Indian Canyons South</td><td style="font-weight: bold;;">8th Annual Palm Springs Desert Classic</td><td style=";">40</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style=";">Sunday, May 3, 2020</td><td style=";">Sunday</td><td style=";"></td><td style="background-color: #B4C6E7;;">Desert Willow Firecliff</td><td style="font-weight: bold;;">8th Annual Palm Springs Desert Classic</td><td style=";">40</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style=";">Friday, May 15, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style="background-color: #F8CBAD;;">Hansen Dam</td><td style="font-weight: bold;;">The Dam</td><td style=";">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style=";">Saturday, May 30, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">Marty Tregnan Memorial</td><td style=";">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style=";">Saturday, June 20, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">The Open</td><td style=";">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">19</td><td style=";">Wednesday, June 24, 2020</td><td style=";">Wednesday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">The International</td><td style=";">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">20</td><td style=";">Friday, July 3, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">Red White and Blue</td><td style=";">64</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">21</td><td style=";">Saturday, July 11, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style="background-color: #F8CBAD;;">Encino</td><td style=";">Encino Man</td><td style=";">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">22</td><td style=";">Saturday, August 1, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">SNIEGOWSKI XI</td><td style=";">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">23</td><td style=";">Wednesday, August 12, 2020</td><td style=";">Wednesday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">The Tune-Up</td><td style=";">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">24</td><td style=";">Friday, August 21, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">83rd Club Championship Qualifier</td><td style=";">120</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">25</td><td style=";">Saturday, August 22, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">83rd Club Championship Qualifier</td><td style=";">120</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">26</td><td style=";">Friday, September 4, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">The Club Championship & Championship Sunday</td><td style=";">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">27</td><td style=";">Saturday, September 5, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">The Club Championship & Championship Sunday</td><td style=";">16</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">28</td><td style=";">Sunday, September 6, 2020</td><td style=";">Sunday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">The Club Championship & Championship Sunday</td><td style=";">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">29</td><td style=";">Saturday, September 19, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">Fall Season Kickoff</td><td style=";">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">30</td><td style=";">Saturday, October 3, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">Oktoberfest</td><td style=";">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">31</td><td style=";">Friday, October 16, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">The President's Cup</td><td style=";">24</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">32</td><td style=";">Friday, October 16, 2020</td><td style=";">Friday</td><td style=";">1pm</td><td style=";">Harding</td><td style=";">The President's Cup</td><td style=";">24</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">33</td><td style=";">Saturday, October 17, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">The President's Cup</td><td style=";">24</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">34</td><td style=";">Friday, October 30, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">Halloween</td><td style=";">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">35</td><td style=";">Saturday, November 14, 2020</td><td style=";">Saturday</td><td style=";">7am</td><td style=";">Wilson</td><td style=";">Turkey Shoot</td><td style=";">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">36</td><td style=";">Wednesday, November 25, 2020</td><td style=";">Wednesday</td><td style=";">7am</td><td style=";">Harding</td><td style="font-weight: bold;;">3 Club Challenge</td><td style=";">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">37</td><td style=";">Friday, December 11, 2020</td><td style=";">Friday</td><td style=";">7am</td><td style=";">Wilson</td><td style="font-weight: bold;;">Christmas Shotgun</td><td style=";">128</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet3</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">M2</th><td style="text-align:left">=SUM(<font color="Blue">Table714[@[Wednesday]:[Saturday]]</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">M3</th><td style="text-align:left">=SUM(<font color="Blue">Table714[@[Wednesday]:[Saturday]]</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">M4</th><td style="text-align:left">=SUM(<font color="Blue">Table714[@[Wednesday]:[Saturday]]</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J5</th><td style="text-align:left">=SUM(<font color="Blue">J2:J4</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K5</th><td style="text-align:left">=SUM(<font color="Blue">K2:K4</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L5</th><td style="text-align:left">=SUM(<font color="Blue">L2:L4</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">M5</th><td style="text-align:left">=SUM(<font color="Blue">Table714[@[Wednesday]:[Saturday]]</font>)</td></tr></tbody></table></td></tr></table><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J2</th><td style="text-align:left">{=SUMPRODUCT(<font color="Blue">(<font color="Red">IFERROR(<font color="Green">FIND(<font color="Purple">J$1,$B$2:$B$37</font>),0</font>)=1</font>)*(<font color="Red">$E$2:$E$37=$I2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K2</th><td style="text-align:left">{=SUMPRODUCT(<font color="Blue">(<font color="Red">IFERROR(<font color="Green">FIND(<font color="Purple">K$1,$B$2:$B$37</font>),0</font>)=1</font>)*(<font color="Red">$E$2:$E$37=$I2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L2</th><td style="text-align:left">{=SUMPRODUCT(<font color="Blue">(<font color="Red">IFERROR(<font color="Green">FIND(<font color="Purple">L$1,$B$2:$B$37</font>),0</font>)=1</font>)*(<font color="Red">$E$2:$E$37=$I2</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
 

Douglas Edward

New Member
Joined
Jul 24, 2018
Messages
22
Re: Need help with countifs formula

Thanks for your reply AhoyNC. Your countif formula is basically the same as mine. I'm trying to delete the Day Column, and just use the Date column.

And the La City courses are Hansen Dam & Encino.
 

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,344
Office Version
365
Platform
Windows
Re: Need help with countifs formula

Try:
Excel Workbook
ACADAEAFAGAHAIAJAKALAMAN
3DateDayTimeLocationTournamentPlayersCourseWednesdayFridaySaturdayTotal
4Friday, January 3, 2020Friday7amWilsonNew Year's Super Skins60Wilson 67
5Saturday, January 11, 2020Saturday7amHardingLeaning Tree Classic60Harding356
6Wednesday, January 22, 2020Wednesday7amHarding3/6 Scramble32LA City Away000
7Saturday, February 8, 2020Saturday7amWilsonThe Bambino60Total
8Friday, February 21, 2020Friday7amWilson1457: Banned by Law60Friday
9Begins in MarchFourball Championship962
10Saturday, March 7, 2020Saturday7amHardingThe Rogow72267
Sheet
 

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,344
Office Version
365
Platform
Windows
Re: Need help with countifs formula

The formula I gave you in post 7 above will only work if your dates in AC are text. If they are actual Excel dates (numeric) then try the array formula below.
I would also suggest that you don't mix dates and text "Begins in March" in the same column.
Enter with CTRL-SHIFT-ENTER.
Excel Workbook
ACADAEAFAGAHAIAJAKALAM
3DateDayTimeLocationTournamentPlayersCourseWednesdayFridaySaturday
4Friday, January 3, 2020Friday7amWilsonNew Year's Super Skins60Wilson 67
5Saturday, January 11, 2020Saturday7amHardingLeaning Tree Classic60Harding356
6Wednesday, January 22, 2020Wednesday7amHarding3/6 Scramble32LA City Away000
7Saturday, February 8, 2020Saturday7amWilsonThe Bambino60Total
8Friday, February 21, 2020Friday7amWilson1457: Banned by Law60
9Begins in MarchFourball Championship96
10Saturday, March 7, 2020Saturday7amHardingThe Rogow72
11Wednesday, March 18, 2020Wednesday7amHardingSt. Patty's Shamble84
12Friday, March 27, 2020Friday7amWilsonArnie's Army60
13Saturday, April 4, 2020Saturday7amWilsonGPGC 36 Hole Championship Day 184
14Sunday, April 5, 2020Sunday7amHardingGPGC 36 Hole Championship Day 284
15Friday, April 24, 2020Friday7amHardingThe Didrikson32
16Saturday, May 2, 2020SaturdayIndian Canyons South8th Annual Palm Springs Desert Classic40
17Sunday, May 3, 2020SundayDesert Willow Firecliff8th Annual Palm Springs Desert Classic40
18Friday, May 15, 2020Friday7amHansen DamThe Dam60
19Saturday, May 30, 2020Saturday7amHardingMarty Tregnan Memorial84
Sheet
 

Twollaston

Board Regular
Joined
May 24, 2019
Messages
223
Re: Need help with countifs formula

double click in the formula highlight this and press f9
(IFERROR(FIND(K$1,$B$2:$B$37),0)=1)
Check the result to see if it's an error, it should be a bunch of trues and falses(ctrl z to put the formal back in)

if there is no error then check this formula using the same method
($E$2:$E$37=$I2)

If you are getting an error in 1 of those, it's likely due to formatting
 

Forum statistics

Threads
1,081,690
Messages
5,360,614
Members
400,592
Latest member
badgergurl

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top