troubleshooting Question

Simple countif but im stuck

Avatar of RainerWiegand
RainerWiegand asked on
Microsoft Excel
11 Comments1 Solution185 ViewsLast Modified:
I have a list of date formatted data in column G3:G500 on sheet 2. I would like to count in cell B5 how many dates are in January and C5 how many dates are in February. Sheet 1)

In B4 I have the 31 Jan 2010 as a ref and in C4 28th Feb 2010 and I would like to write something like:

=COUNTIF('sheet1'!G$3:$G$20000,<=B4)

Anybody can help please as I was sitting a few hours on this already :(

Thanks

Rainer
ASKER CERTIFIED SOLUTION
Saqib Husain
Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros