Well, that's good to hear - thanks for feeding back.

Can you set our minds to rest, though, and tell us what you did - what was
wrong with the data that made all those suggested formulae not work?

Pete

"Civette" wrote in message
...
IT worked. Yeah. I did a bit of data manipulation and it's working.
Thank
you all for your help

"Pete_UK" wrote:

It might also be that the number that looks like 1247.24 is not actually
that value - if the cell is formatted to 2 dp then it could be any number
between 1247.235 and 1247.2449999etc, so you might like to change the
first
condition to:

(ROUND(E4:E869,2)=1247.24)

Hope this helps.

Pete

"Pete_UK" wrote in message
...
Yes, it might be that your dates are text values that just look like
dates, or that the numbers in column E are not really numbers but text
values also. I see in your comments to Biff that you are not searching
for
a specific date, so you might like to try these:

=SUMPRODUCT((E4:E869=1247.24)*(AC4:AC869<""))
and:
=SUMPRODUCT((E4:E869="1247.24")*(AC4:AC869<""))

to see which of them give you an answer other than zero.

Hope this helps.

Pete

"Civette" wrote in message
...
Tried, and it didn't work. Could I be getting snagged on some type of
formatting glitch?

"Pete_UK" wrote:

Try it this way:

=SUMPRODUCT((E4:E869=1247.24)*(AC4:AC869=--"01/01/2006"))

You can't mix up text and numbers.

Hope this helps.

Pete

"Civette" wrote in message
...
I have a spreadsheet containing thousands of records (each row is a
different
record) and 20 different data columns.

I want to count the number of records when the a specific number is
in
one
column and a date (any date) appears in the second column. The
column
containing the dates may also contain blank cells, since this
column
is
not
filled in until some action triggers the need to put in a date.
I've
tried
the following formula and get "0". Can someone help?

=SUMPRODUCT((E4:E869="1247.24")*(AC4:AC869="01/01/2006"))