Microsoft Office Forums - View Single Post - Countif containing specific month

Thread: Countif containing specific month

View Single Post

Old

03-17-2018, 04:35 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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.

Reply With Quote