#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Thank you!
|
|
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 |