Nested Functions in Excel2003

[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

 

[Teethless mama]

=SUMPRODUCT(--(A1:A100=A26),--(TEXT(G1:G100,"m/yyyy")="1/2008"))

You can not use whole columns prior to Excel 2007