Count if date is Monday (or any specific day)

Hi JoMa2,

I tried several methods, and this is one method that works. insert another column in Table 1 (Column B in this example. You can hide this column when all is good).

Formula in Table 1: DAYNAME(A2)

Fill Down.

In the table "Count days of the week", formula in B2: COUNTIF(Table 1::B,A2)

The table "Count days of the week" has one Header Row and one Footer Row.

Formula in Footer Cell B9: SUM(B)

Formula in C2: B2÷B$9×100

Fill down.

Please reply with questions, and happy Numbering!.

Regards,

Ian.

Starting with Numbers 11.2, in addition to Ian's excellent approach, you can also use a Pivot Table. Just a few clicks and drags and you have your answer in a few seconds. No formulas!

Start by clicking your table and choosing Organize > Create Pivot Table > On Current Sheet from the menu.

Then set it up this way by dragging Fields into the Rows and Values boxes:

You click the circled i's for options:

SG

Expanding the Pivot Table solution to include percentages (it took a few more seconds):

SG