Countif that contains partial date (month)

Dragongal

New Member
Joined
Dec 16, 2021
Messages
1
Office Version
  1. 365
  2. 2019
  3. 2010
Platform
  1. Windows
Sorry if someone aldy posted something similar. With regards to year. But I can’t seem to apply it. So I guess I have to start a new one here.

I’m not really good with complex formula. So trying to keep it simple to my knowledge capability.

I’m trying to count how many delivery for each mth within a column. I’ve tried changing to text but it doesn’t work cos the date is still 1/1/2021 under text format. 😓😓
Countif(E5:E1346,”*Jan*”) cannot work
Countif(E5:E1346,”*/2/*”) also cannot work.

If I stick to date format,
I saw someone post a complex solution for year.
=SUMPRODUCT(- -(YEAR(column range)=2017)
But I don’t understand n unable to apply it to my situation.
=SUMPRODUCT(- -(Month(column range)=Jan)

Can someone help?
 

Attachments

  • B8D16406-AD1A-4BA0-B364-8AA25A9F3090.jpeg
    B8D16406-AD1A-4BA0-B364-8AA25A9F3090.jpeg
    39.1 KB · Views: 6

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,929
Office Version
  1. 365
Platform
  1. Windows
Try:
SUMPRODUCT(- -(Month(column range)=1)

Book1
BCD
1Count Jan
21-Jan-214
35-Jan-21
46-Jan-21
57-Feb-21
621-Jan-21
Sheet1
Cell Formulas
RangeFormula
D2D2=SUMPRODUCT(--(MONTH(B2:B6)=1))
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,440
Messages
5,831,643
Members
430,079
Latest member
lucasabreueng

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
Top