CountIfs formula Issue

[chris007]

hello Everyone, i have a probably a simple problem to the experienced, for me i have been rattling my brain for the past 3 hrs.

i am using excel 2016 from Microsoft Suite.

My Current Formula.

=COUNTIFS(AA2:AA178,"Submitted",$AA$2:$AA$178,">="&DATE(2017,9,1),$AA$2:$AA$178,"<="&DATE(2017,9,30))

Formula result is "0"

I have tried this formula =COUNTA(AA2:AA178,AD2:AD178 (Submitted),$AA$2:$AA$178,">="&DATE(2017,9,1),$AA$2:$AA$178,"<="&DATE(2017,9,30)) and this returns a value of (48) not the expected (18)

I have the date in AA Column (column formatted to date (04-Sept-17)

What I am trying to Achieve is to count how many times "Sept" appears in Column AA2:AA178 and only if column Ab2:ab178 has the word "Submitted"

I hope i have provided enough information and not confused anyone

Thank you
and Thank you for this forum it has certainly helped me

 

[AhoyNC]

Shouldn't your range for "Submitted" be AB2:AB178 ?
[TABLE="width: 761"]
<colgroup><col width="761"></colgroup><tbody>[TR]
[TD="width: 761"]COUNTIFS(AB2:AB178,"Submitted",$AA$2:$AA$178,">="&DATE(2017,9,1),$AA$2:$AA$178,"<="&DATE(2017,9,30))
[/TD]
[/TR]
</tbody>[/TABLE]

 

[chris007]

Thank you AhoyNC
You are correct, Sometimes you overlook the obvious and need someone to point it out
it woes with no broblems

Thank you Again
Much apprecaited

 

[AhoyNC]

You're welcome. We all overlook the obvious at times. Thanks for the feedback.