Copy Down sum formula with conditon

hello
i m using below formula in column C4 to sum a range

Please Login or Register  to view this content.

when i fill down the formula in column C5, i m getting result

Please Login or Register  to view this content.

,
but i want the result

Please Login or Register  to view this content.

and i fill down one more time then result should be

Please Login or Register  to view this content.

, all time different with 43 rows

thanx

Try this in C4:
confirmed with ctrl+shift+enter (not just enter)

Formula:

Please Login or Register  to view this content.

HELLO Mod : zbor

thanx u save my lots of time

will add u +1 reputation

Ups!
sorry HaHoBe
i was in hurry, so posted in wrong sub forum

btw

ur code is working too much perfect

thanx u saved my space

will add u too +1 repu

note: i will remain in future to post a thread in right sub forum

I've moved it now.

Thanx Mod zbor