Problem Counting a Range of Numbers

[Jim]

I am trying to create a formula that will tell me how many reports were filed within a specific number of days, in this case 6 days, each month. The number of days is based on the date in one column being subtracted from the date in a second column, with the result being listed in a third column as C1-B1 and formatted to show a number. The columns have been named as shown below

The basic formula I am using is
{=sum((Year=2004)*(Month=â€Octâ€)*(Days=<6))}

All I am getting as an answer is 0. Any ideas on what is happening and what the formula should look like

 

[Frank Kabel]

Hi
can you post some example rows of your data (plain text
please)

-----Original Message-----
I am trying to create a formula that will tell me how

many reports were filed within a specific number of days,
in this case 6 days, each month. The number of days is
based on the date in one column being subtracted from the
date in a second column, with the result being listed in a
third column as C1-B1 and formatted to show a number. The
columns have been named as shown below.

The basic formula I am using is:
{=sum((Year=2004)*(Month=â?Octâ?)*(Days=<6))}

All I am getting as an answer is 0. Any ideas on what is

happening and what the formula should look like?

 

[Guest]

The function you should use is "=COUNTA(range)" This
will count each cell that has any format of data in the
cell.

-----Original Message-----
I am trying to create a formula that will tell me how

many reports were filed within a specific number of days,
in this case 6 days, each month. The number of days is
based on the date in one column being subtracted from the
date in a second column, with the result being listed in
a third column as C1-B1 and formatted to show a number.
The columns have been named as shown below.

The basic formula I am using is:
{=sum((Year=2004)*(Month=â?Octâ?)*(Days=<6))}

All I am getting as an answer is 0. Any ideas on what

is happening and what the formula should look like?

 

[Frank Kabel]

Hi
why not use
=SUMPRODUCT(--(YEAR(C1:C100)=2004),--(MONTH(C1:C100)=10),--(E1:E100<=6)
)