B
BDUB
HELP!!!
I am trying to create a function that identifies how many times a particular
cell value shows up between dates, then add up the frequency. I have two
separate functions, that I would like to combine into one.
=COUNTIF(Data!A:A,A26)
=COUNTIF(Data!G:G,">=01/01/08")-COUNTIF(Data!G:G,">=01/31/08"))))
-I know that the first half will check the A column in the Data sheet, and
count it if the value matches on the 'index' sheet.
-I know that the second half of this will give me the instances for how many
times a value of January 08 occurs in Data column G.
However, I am trying to count ONLY the value in A26, that occur in January 08.
Any help would be appreciated!
BDUB
I am trying to create a function that identifies how many times a particular
cell value shows up between dates, then add up the frequency. I have two
separate functions, that I would like to combine into one.
=COUNTIF(Data!A:A,A26)
=COUNTIF(Data!G:G,">=01/01/08")-COUNTIF(Data!G:G,">=01/31/08"))))
-I know that the first half will check the A column in the Data sheet, and
count it if the value matches on the 'index' sheet.
-I know that the second half of this will give me the instances for how many
times a value of January 08 occurs in Data column G.
However, I am trying to count ONLY the value in A26, that occur in January 08.
Any help would be appreciated!
BDUB