Count based on dates in different column

[sprytgrrl]

Hi! This question has probably been asked a million times before but I still can't get my formulas to work right! Here's what I'm trying to do.

On SheetX!A1, count SheetZ!B:B >DateB IF SheetZ!A:A < DateA

So...On SheetX!A1, count SheetZ!B:B >2/28/2010 only IF SheetZ!A:A < 2/1/2010

Column: A B
1/1/2010 3/1/2010
1/15/2010 2/1/2010
2/19/2010 3/1/2010
2/28/2010 2/1/2010

The count would be one. I've tried sumproduct but get a #Num error.
=SUMPRODUCT((Jan20110302!H:H<DATE(2011,1,1)),(Jan20110302!M:M>=DATE(2011,1,31)))
Thank you!!

 

[VoG]

Hi. Try like this



=SUMPRODUCT(--(Jan20110302!H1:H100<=DATE(2011,2,28)),--Jan20110302!H1:H100>DATE(2010,2,1)))

 

[njimack]

=sumproduct(--(z!$b$1:$b$4>40237),--(z!$a$1:$a$4<40210))

 

[sprytgrrl]

Dumb question.... do i leave the dashes -- in or does that represent something?

 

[VoG]

Leave them in or the formulas won't work.

 

[sprytgrrl]

That worked. Thank you both!!