Count function

Resolved · Low Priority · Version 365

Wed 12 Oct 2022, 16:45 Delegate Sophie said...

Sophie has attended:
Excel Intermediate course

Count function

I would like to count the total number of cells that contain each month from a date format

Thu 13 Oct 2022, 08:55 Trainer Marius said...

RE: count function

Hi Sophie,

Thank you for your question. The simplest way to do this would be to insert a column which shows the month from a date as a number.

The function is: =MONTH(B2) - if the dates are in column B. It will show 1 for Jan, 2 for Feb, etc.

In another column, write a COUNTIF function to count the number of e.g., Feb's (2s).

=COUNTIF(C:C,2) - Column C has the =MONTH functions.

I hope this helps!

Kind regards
Marius Barnard
STL

Thu 20 Oct 2022: Automatically marked as resolved.

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips

Count function

Count function

RE: count function

Excel articles

Excel tip:

Using Excel's MODE function