#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 39
Default Countif problems

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.
--
Drew C
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default Countif problems

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



--
Jacob


"Drew" wrote:

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.
--
Drew C

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with countif function NavyGunner Excel Discussion (Misc queries) 3 August 7th 08 05:41 PM
Problems with COUNTIF formulae Mackem Excel Discussion (Misc queries) 2 November 6th 07 12:55 PM
COUNTIF Problems PW11111 Excel Discussion (Misc queries) 1 July 25th 05 12:09 PM
problems with sumif and countif Simon Shaw Excel Discussion (Misc queries) 6 July 23rd 05 10:02 PM
COUNTIF formula problems artisanpp Excel Discussion (Misc queries) 2 June 5th 05 01:30 AM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"