Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with countif function | Excel Discussion (Misc queries) | |||
Problems with COUNTIF formulae | Excel Discussion (Misc queries) | |||
COUNTIF Problems | Excel Discussion (Misc queries) | |||
problems with sumif and countif | Excel Discussion (Misc queries) | |||
COUNTIF formula problems | Excel Discussion (Misc queries) |