Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting a text value between dates
I am trying to count the number of times a particular phrase occurs in a
column using a combilation of 'if' and 'countif' my knowlegde of basic dates back to the time when every line started with a number! but I am trying to do something along the lines of IF !$I:$I 01/01/09 or !$I:$I <31/01/09 then CountIf !$B:$B = "B02 But nothing I seem to do brings up the correct result, any help gratefully received. Lucy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting a text value between dates
Better to use SUMPRODUCT. See countless examples in the archives of this
group. -- David Biddulph "Lucy_C" wrote in message ... I am trying to count the number of times a particular phrase occurs in a column using a combilation of 'if' and 'countif' my knowlegde of basic dates back to the time when every line started with a number! but I am trying to do something along the lines of IF !$I:$I 01/01/09 or !$I:$I <31/01/09 then CountIf !$B:$B = "B02 But nothing I seem to do brings up the correct result, any help gratefully received. Lucy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting a text value between dates
=SUMPRODUCT(--(I2:I30DATE(2009,1,1)),--(I2:I30<DATE(2009,1,31)),--(B2:B30="B02"))
Adjust ranges! If you want to refer entire columns you must use Excel2007! Regards, Stefi €˛Lucy_C€¯ ezt Ć*rta: I am trying to count the number of times a particular phrase occurs in a column using a combilation of 'if' and 'countif' my knowlegde of basic dates back to the time when every line started with a number! but I am trying to do something along the lines of IF !$I:$I 01/01/09 or !$I:$I <31/01/09 then CountIf !$B:$B = "B02 But nothing I seem to do brings up the correct result, any help gratefully received. Lucy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Dates - Not Text | Excel Worksheet Functions | |||
Counting Dates - Not Text | Excel Worksheet Functions | |||
Counting Dates - Not Text | Excel Worksheet Functions | |||
counting occasions dates occur between 2 dates | New Users to Excel | |||
Counting dates, within a list of dates | Excel Worksheet Functions |