Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a column of dates, there can be multiples of the same date, so I
created a summary sheet that will say for 5/6/08 there were 10, using the countif function. However in 2007 Excel when using the function wizard it puts something called "Extract" when clicking on the date field. However the formula doesn't work anyway. My current formulat is =COUNTIF(YesNo3D!E:E,Extract). Column E has all the dates dates. On my summary column I have unique dates and next to it is this formulate to try and count the times my unique date occur? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
countif / sumproduct or something else? | Excel Discussion (Misc queries) | |||
Countif or Sumproduct | Excel Worksheet Functions | |||
SUMPRODUCT - comma versus semicolon | Excel Worksheet Functions | |||
SUMPRODUCT search versus other method | Excel Discussion (Misc queries) | |||
SumProduct or CountIf | Excel Worksheet Functions |