Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif versus SumProduct
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif versus SumProduct
I think Extract may be a named range which contains the unique dates
you have extracted from those in column E. You certainly get this appearing in the named range list in earlier versions if you use Advanced filter to generate a list of unique values. If you are more comfortable with it, change the formula to: =COUNTIF(YesNo3D!E:E,A1) if your first unique date on the summary sheet is in A1, then copy down. Hope this helps. Pete On Jul 1, 5:55*pm, Rookie_User wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif versus SumProduct
Your awesome!! Yes I did use the advanced filter to get the unique dates -
this didn't happen in my pre 2007 version of Excel I don't think. I will try what you suggested but great diagnosing. :) "Pete_UK" wrote: I think Extract may be a named range which contains the unique dates you have extracted from those in column E. You certainly get this appearing in the named range list in earlier versions if you use Advanced filter to generate a list of unique values. If you are more comfortable with it, change the formula to: =COUNTIF(YesNo3D!E:E,A1) if your first unique date on the summary sheet is in A1, then copy down. Hope this helps. Pete On Jul 1, 5:55 pm, Rookie_User wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif versus SumProduct
Thanks for your kind words (and I don't even have XL2007!!).
Pete On Jul 1, 9:20*pm, Rookie_User wrote: Your awesome!! Yes I did use the advanced filter to get the unique dates - this didn't happen in my pre 2007 version of Excel I don't think. *I will try what you suggested but great diagnosing. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |