Ed,

Yes, you've got it. SUMIF and COUNTIF support wildcards, SUMPRODUCT doesn't,
but as you can see from Frank and my super-clever workaround <vbg, there
are ways and means. The date thing was tricky, seeing it fornatted as a date
led us both to assume that it was a date (and we all know what assuming
does).

Anyway, it's good you are sorted.

Bob

"Ed" wrote in message
...
Frank and Bob:

So in this instance, FIND was looking for the "*" character, rather than
using it as a wildcard? I'll have to remember that one! And I should
have
caught that date vs. number thing - a simple check of cell format would
have
told me. *SIGH* All these details - guess that's what makes you guys
good!
8)

Thank you so much for all your help.
Ed