Countif problems

  • Thread starter Thread starter Drew
  • Start date Start date
D

Drew

I am currently trying to write a formula that looks up a centre eg Boston and
then, from another column, how many 'Bostons' appear between two given dates.
Is this possible?
Although I am writing this formula other people will have to use it and
change the date ranges regularly so it can't be overly complicated.
 
With data arranged as below try the below formula. Query dates are in cells
C1 & D1

=SUMPRODUCT((A1:A7>=C1)*(A1:A7<=D1)*(B1:B7="Boston"))

Col A Col B Col C Col D
1/25/2010 Boston 1/25/2010 1/28/2010
1/26/2010 NY
1/27/2010 Boston
1/28/2010 NY
1/29/2010 Boston
1/30/2010 NY
1/31/2010 Boston
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Excel Dragging countif formula with changing criteria 3
COUNTIF & Dates 0
Excel Need Countifs Formula Help 0
COUNTIFS AND CRITERIA 2
Countifs with same reference? 17
Countif function 3
possible countif formula? 3

Back
Top