Ok, I see what you're trying to do.

Well, all that was wrong with the formula was the missing parenthesis. There
might be data type mismatches: text numbers versus numeric numbers.
Leading/trailing spaces or other unseen whitespace characters.

--
Biff
Microsoft Excel MVP


"LisaM" wrote in message
...
No, I'm not trying to do the calculation on filtered data. What I'm trying
to
do is double check my results by doing the calculations in two different
ways
- one with the function I posted and one with filters (and the autofilter
is
working with different columns).

What I'm hoping is that both ways of calculating the data will yield the
same results, but unfortunately, they're not.

"T. Valko" wrote:

If you're wanting to do that calculation on filtered data then you'll
need a
completely different formula. That formula will return the same result
whether the data is filtered or not.

--
Biff
Microsoft Excel MVP