Greater than or Equal to and dates

  • Thread starter Thread starter mike p.
  • Start date Start date
M

mike p.

Hey,

I need some help. I have a spreadsheet that contains 2
rows...date and designation. I need a formula that will
search the dates by ranges and then count how many have a
certain designation.

ex.

A | B
Up 12/20/2003
up 12/20/2003
down 1/02/2003
up 12/27/2003
down 12/13/2003

i need to figure out how to just count cells that are for
specific dates...like how many "Up" fall before 12/28/2003
or how many "down" fall directly on 12/13/2003...

PLEASE HELP
 
You can use a SUMPRODUCT formula, e.g.:

=SUMPRODUCT((A2:A6="up")*(B2:B6<DATE(2003,12,28)))
or
=SUMPRODUCT((A2:A6="down")*(B2:B6=DATE(2003,12,13)))
 
Back
Top