Hello.

About a year ago, someone here helped me with an array formula which would
only sum the visible items in a filtered list. I thought that was done with
SumProduct, but unfortunately, I can't seem to find that example, nor get it
to work right now.

An exampe would be if data were like this:

A B C
1 r 5
1 o 10
3 r 15
1 r 20

We want to sum column C when column B = 'r', but also only when the item is
visible, if autofiltered.

So, pretend a filter were applied so that colum A had to be 1, the visible
items would be:

A B C
1 r 5
1 o 10
1 r 20

and the result of the formula I'm looking for would be 25.... the 5 in the
first row, and the 20 in the last row.

I'm sorry I can't fine where this was done before, but can comeone show me
how to do that? Thank you.