Countif containing specific month

		Microsoft Office Forums > Microsoft Excel > Excel
Countif containing specific month

FAQ

Thread Tools

Display Modes

03-17-2018, 04:35 AM

xor

Windows 10 Countif containing specific month

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

If I understand you correct:

Helper cells E4:E14 where you put the following formula in E4: =MONTH(D4)
and copy down to E14.

Then:

=SUM(1/MMULT((IF((C4:C14="Wheatfields"),E4:E14)=TRANSPOSE (IF((C4:C14="Wheatfields"),E4:E14)))+0,ROW(E4:E14) ^0))-1

This is an array formula so when completing it hold down Ctrl and Shift before pressing Enter.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with IF and COUNTIF functions	jester296	Excel	1	05-13-2015 09:09 AM
CountIF Functions	Alaska1	Excel	4	01-30-2015 09:59 AM
COUNTIF Formula	teza2k06	Excel	3	02-13-2014 12:37 PM
Countif	hockeytown	Excel	3	01-05-2013 08:06 AM
Countif issue	Katy I	Excel	2	07-11-2012 06:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:40 PM.