Assuming that they are hidden via filter, this sums the values in E when C
is filtered, and D = Assigned

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Verlaesslichkeit" wrote in
message ...
Pease, I need some help!

I want to sum a column with a criteria (in this case another column with
selective creiteria = 1) but I dont want hidden rows to be included. It
should be a function that is a subtotal yet taking in consideration a
criteria. Any ideas? Thanks a lot!