Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-16-2018, 03:38 PM
baes10 baes10 is offline Countif containing specific month Windows 7 64bit Countif containing specific month Office 2007
Advanced Beginner
Countif containing specific month
 
Join Date: Dec 2017
Posts: 33
baes10 is on a distinguished road
Default Countif containing specific month

Hi there, could you help me with a simple formula to count the number of months in column D within specific year (2018) if column C contains "Wheatfields"?
I'm struggling.. Thank you!
Attached Images
File Type: jpg Capture1.JPG (123.0 KB, 24 views)
Reply With Quote
  #2  
Old 03-17-2018, 01:13 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Countif containing specific month Windows 7 64bit Countif containing specific month Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Do you mean that more than one order the same month only counts for one?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 03-17-2018, 04:35 AM
xor xor is offline Countif containing specific month Windows 10 Countif containing specific month Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor 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
  #4  
Old 03-26-2018, 06:33 PM
baes10 baes10 is offline Countif containing specific month Windows 7 64bit Countif containing specific month Office 2007
Advanced Beginner
Countif containing specific month
 
Join Date: Dec 2017
Posts: 33
baes10 is on a distinguished road
Default

Thank you!
Reply With Quote
Reply

Thread Tools
Display Modes


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 containing specific month COUNTIF Formula teza2k06 Excel 3 02-13-2014 12:37 PM
Countif hockeytown Excel 3 01-05-2013 08:06 AM
Countif containing specific month 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 02:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft