Problem Counting a Range of Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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
Click to expand...
happening and what the formula should look like?
 
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
Click to expand...
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
Click to expand...
is happening and what the formula should look like?
 
Hi
why not use
=SUMPRODUCT(--(YEAR(C1:C100)=2004),--(MONTH(C1:C100)=10),--(E1:E100<=6)
)
 
Back
Top