"Sarah H." wrote in message
...

=SUBTOTAL(DataCol("Foo"),--(DataCol("Foo")0),--(DataCol("Bar")="C"))

Whoops, that was supposed to say:

=SUMPRODUCT(DataCol("Foo"),--(DataCol("Foo")0),--(DataCol("Bar")="C"))

But I'm sure you got the idea.

--
Sarah

Hi, folks!

I'd like help coding a VBA function. Here's what I'm looking for: I want
to be able to use the function in a formula like this:

dataCol("Foo")
. . .