COUNTIFS Help

[mjmoon]

I need a work around solution to this formula. Where I have 02/23/11, 03/1/11 and Pending set for the criteria I want to replace that with a cell reference instead. The formula works correctly as is, but I want the criteria to be based off a cell reference. Cell A3 is 2/23/11, A4 is 3/1/11 and A5 is Pending.

=COUNTIFS(B2:B13,">=02/23/11",B2:B13,"<=03/1/11",E2:E13,"=Pending")

When I type the formula in this way it doesn't give me the save results.
=COUNTIFS(B2:B13,">=A3",B2:B13,"<=A4",E2:E13,"=A5")

Any suggestions?

Thank you in advance.

 

[VoG]

Try

=COUNTIFS(B2:B13,">="&A3,B2:B13,"<="&A4,E2:E13,A5)

 

[mjmoon]

That was easy. Thanks.