| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count for matching requirement?
Does anyone know how to count for matching requirement?
In cell a1 = today(), there are a lists of date in column B:D, and I would like to find out how many cell match the specific date in cell a1 within B:D, and return the count into cell a2. Does anyone have any suggestion? Thank you in advance Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to count for matching requirement?
Try this:
=COUNTIF(B:D,A1) Biff "Eric" wrote in message ... Does anyone know how to count for matching requirement? In cell a1 = today(), there are a lists of date in column B:D, and I would like to find out how many cell match the specific date in cell a1 within B:D, and return the count into cell a2. Does anyone have any suggestion? Thank you in advance Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count values in two columns | Excel Discussion (Misc queries) | |||
| Need formula to count spinoffs | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
Linear Mode
