=SUMPRODUCT(--(Jan!B3:B400='Daily totals'!B3),--(Jan!FO3:FO400<="1"))

Remove the quotes from around the 1:

=SUMPRODUCT(--(Jan!B3:B400='Daily totals'!B3),--(Jan!FO3:FO400<=1))

When you quote numbers Excel then evaluates them as TEXT.

--
Biff
Microsoft Excel MVP


"marsjune68" wrote in message
...
Thank you that worked! How about this one. I thought I could get it to
work
but its not working very well. Here is the issue.
Sheet "Daily totals" Every Row has a date. I want to see daily what each
total was. I will be doing this for every day of the year. I can get my
totals for Col C and Col D to work. But they are a different formula.

date total total total
Col B Col C Col D Col E
Row 1 1/1/09 0 0 0
Row 2 1/2/09 7 5 5
Row 3 1/3/09 15 2 11
Row 4 1/4/09 9 5 9
Row 5 1/5/09 7 1 7
Row 6 1/6/09 1 0 1

Col E Formula is
=SUMPRODUCT(--(Jan!B3:B400='Daily totals'!B3),--(Jan!FO3:FO400<="1"))

Sheet "Jan"
Col B Col FO
1/2/09 2
1/2/09 0
1/2/09 0
1/2/09 1
1/2/09 1
1/2/09 2
1/2/09 0
1/3/09 1
1/3/09 0
1/3/09 4
1/3/09 0
1/3/09 0
1/3/09 1
1/3/09 0
1/3/09 0

"Col FO" formula is =COUNTIF(U3:FK3,"y")
I get accurate total from the formula =COUNTIF(U3:FK3,"y") this part works
right.

I can not get my Daily total in "Col E of sheet Daily Totals" to total
right. On the 1/2/09 will but 1/3/09 seems to count the 1/2 and 1/3
dates.
I want to know the total from "Sheet Jan" on a given day to total up in
the
approprate date on the Daily totals sheet.

"marsjune68" wrote:

I want to count the number of "x" in a given date range in sheet2. sheet1
has
every date listed from Jan1 2009 thru Dec 31 2009 I want to see daily
how
many "X" I have. The total should post in to col B of sheet1.


Sheet 1 has dates in col A col B is where I want the result from the
cout
of "X" to go.

date total
col A col B
row1: 1/1/09 3
row2: 1/2/09 2
row3: 1/3/09 1
row4: 1/4/09

SHEET 2
has multiple entries for each day


date "X" or "Y"
col A col Z
row1: 1/1/09 x
row2: 1/1/09 y
row3: 1/1/09 x
row4: 1/1/09 x
row5: 1/2/09 y
row6: 1/2/09 x
row7: 1/2/09 x
row8: 1/3/09 y
row9: 1/3/09 x
row10: 1/3/09 y

I am killing myself trying to figure it out but I can not. I hope it is a
easy one. But I can not figure it out. If someone could help me I would
be
happy.