Countifs formula

D

Douglas Edward

New Member
Joined
Jul 24, 2018
Messages
22
Office Version
  1. 2019
Platform
  1. Windows
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>
 
Sort by date Sort by votes
Re: Need help with countifs formula

You're welcome, glad you got it working. Thanks for the feedback
 
Upvote 0

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
You must log in or register to reply here.

Similar threads

RAJESH1960
  • Solved
If function with Countif formula
Replies
3
Views
341
6StringJazzer
6StringJazzer
N
  • Question
Nested IF help
Replies
0
Views
476
nikhil0311
N
M
  • Question
Adding two IF Statements Together
Replies
1
Views
389
MrNerd
M
L
  • Question
Sum Week To Date Sales
Replies
3
Views
646
sheetspread
S
B
  • Question
Auto populate names to weekly rotating schedule tabs
Replies
0
Views
2K
Badeddie
B

Forum statistics

Threads
1,214,861
Messages
6,121,969
Members
449,059
Latest member
oculus

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top