Countif problems

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.
 
J

Jacob Skaria

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

Using <= in countifs statement 1
countifs Function not giving desired result with date criteria 2
Excel Countif Function - Calculating Between Two Sets of Values 3
COUNTIFS AND CRITERIA 3
Countif function 3
Sumif apllying to all sheets in workbook 2
Excel 2010 countifs for date range 3
possible countif formula? 3

Top