Thank for the feedback, cheers

"Werner Rohrmoser" wrote:

Thank you xlmate,
I modified your formula like this (see at the end ",0,1"):
=SUM(IF(ISNUMBER(Data),Data)*(SUBTOTAL(3,OFFSET(Da ta,ROW(Data)-MIN(ROW
(DataÂ*)),0,1))))
and now it works perfect.

Werner