| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if dates meet certain criteria
Thank you, that did the trick.
-- Robert K "Jacob Skaria" wrote: Hi Robert You can try the below formula. Please note that this is an array formula. An array formula can perform multiple calculations and then return either a single result or multiple results. Array formulas act on two or more sets of values known as array arguments. Each array argument must have the same number of rows and columns. You create array formulas in the same way that you create other formulas, except you press CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar' you can notice the curly braces at both ends like "{=<formula}" =SUM((IF(A1:A1000,IF(A1:A100<C1,1,IF(B1:B1000,IF (B1:B100<C1,1,0)))))) If this post helps click Yes --------------- Jacob Skaria "RobertK" wrote: I have a spreadsheet similar to this. I need to count the number of dates in column A that are less than C1. If the date in column A is greater than C1 than I want to count the date in column B if it is less than C1. If the date in column A & B are both less than C1 they should count as 1 and not 2. In the example below 9 dates meet the criteria (8 in column A and 1 in column B). Also the database length will vary and will contain blank cells after the last entry in column A. A B C 1/2/2009 3/2/2008 9/16/2009 3/2/2009 6/5/2008 6/5/2008 9/4/2008 3/1/2010 1/1/2010 4/1/2009 7/5/2009 9/15/2008 9/15/2009 12/4/2008 11/4/2008 2/12/2009 3/12/2010 -- Robert K |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count cells that meet 2 criteria | Excel Worksheet Functions | |||
| count rows that meet certain criteria | Excel Discussion (Misc queries) | |||
| Count Cells that meet Criteria | Excel Worksheet Functions | |||
| pulling back dates that meet certain criteria | Excel Worksheet Functions | |||
| how do I count the numbers of row that meet 2 criteria | Excel Worksheet Functions | |||
Hybrid Mode
