Any chance that it's just a typo. Maybe it's a zero/oh thing in either the
formula or the data???

If you just used =countif() to test the stuff in column D, do you get something
bigger than 0?

If you apply data|filter|autofilter to that range. Filter to show 012U and then
=subtotal(9,u3:u1699), what's returned?

(I'd guess data problems--not formula.)

And check for leading/trailing spaces and text that looks like numbers.

Rachel wrote:

An example of the formula that is returning "0" is:
=SUMPRODUCT((ELI!$D$3:$D$1699="012U")*(ELI!$U$3:$U $1699=0))

"012U" corresponds to "P2" in the simplified example I gave before... it's a
person's 'name'...
ELI! is my data source worksheet in the same notebook.

The same formula works when instead of "012U" I have "010U" or "102P" or any
other person's 'name' in that slot.
The same formula also works when I sort sections of data relevant to "010U",
"102P", etc...
All similar sumproduct formulas with "012U" [such as:
=SUMPRODUCT((ELI!$D$3:$D$1699="012U")*((ELI!$S$3:$ S$1699=12)+(ELI!$S$3:$S$1699=14))*(ELI!$V$3:$V$169 9=11)*(ELI!$U$3:$U$1699=0))]

also don't work...

Looking forward to your response.

"Bob Phillips" wrote:

What's the offending formula Rachel, and one that still works?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Rachel" wrote in message
...
Hello there!
I have two worksheets in a notebook:
One is the data source, the other is a lot of "sumproduct" formulas
tabulating totals.

Everything seemed to be working fine, then...
One of the rows in the tabulating worksheet started outputting zeros
instead
of the totals it was giving me before.

Any idea what is happening?
(Below I state the problem in a different way:)

My tabulating worksheet looks like this (Column 'A' is labels, B and C
columns have formulas):
A B C
--|---------------------
1| P1 F1a F2a
2| P2 F1b F2b
3| P3 F1c F2c
4| P4 F1d F2d


This shows that the column B (sumproduct) formulas are exactly the same
for
every 'P' except for one condition (i.e. factor).
Also, column C (sumproduct) formulas are exactly the same, except for one
condition/factor.
The factor (a, b, c, d....) that distinguishes P1's F1 formula from P2's
F1
formula is the same factor that distinguishes P1's F2 formula from P2's F2
formula.

I did a sort on a section of data (that corresponding to P2) on the source
data worksheet, and upon calculating, all formulas in that row outputted
"0".

I have tried reentering them, creating a new column, checked the source
data... I can't figure it out. It seems specifically to have to do with
the
factor/condition in those formulas, although it was working fine
previously.

Any leads are greatly appreciated!

Thanks!
--Rachel.






--

Dave Peterson