This is an example of counting with a filtered list

=SUMPRODUCT(SUBTOTAL(3,OFFSET(C1,ROW($C$2:$C$19)-ROW($C$1),,1)),--($C$2:$C$1
9="the value"))

and summing

=SUMPRODUCT(SUBTOTAL(3,OFFSET(C1,ROW($C$2:$C$19)-ROW($C$1),,1)),
--($C$2:$C$19="IDFM"),$D$2:$D$19)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nigel RS" <Nigel wrote in message
...
Hi All
I have been successfully using sumif and countif to group summary results.
I also use subtotal to return sums and counts for autofiltered lists.

How do I combine autofiltered lists into my sumif and countif statements?
I
could write the VBA code but would prefer a worksheet formula solution.
Thanks