How can I adapt the included filter example to search for more th.

=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX($E$16:$E$1998,1,1),ROW($E$16:$E$1998)-
ROW(INDEX($E$16:$E$1998,1,1)),0))=1),--($E$16:$E$1998="Y"))

I am using this formula to calculate cells and then sort columns also. I
would like to be able to calculate other items in the same field as well
those that are equal to "Y". For example, subtotal everything in cells
E16:E1998 that contains either a "Y", "YY" or a "YN". Is there a OR function
I can place in this formula that will enable this to happen? Thanks in
advance for any help you may offer! - Cheryl

Hi!

I don't have a clear picture of your data, but I suspect you might find it useful to iinvestigate Data > Subtotals... and Data > Filter >Autofilter both of which offer useful ways of counting, grouping, totalling and so on.

Alf