reset countif problems

**johan_van07** · 11-02-2008, 12:16 PM

I would like to have a spreadsheet that changes if have different criteria and "restart" the counter.

Help me guys...

Many Thanks
Johan_Van

**robert111** · 11-02-2008, 12:36 PM

see attached, if you delete the yellow date the total sets back

**johan_van07** · 11-02-2008, 10:06 PM

thanks robert for your reply,

but i'm expecting something more like the attached file...
a reset counter after the criteria changed.

**rylo** · 11-02-2008, 10:22 PM

Hi

Using your example file structure, try

Please Login or Register  to view this content.

in B12 and copy across.

rylo

**johan_van07** · 11-02-2008, 11:31 PM

Thanks Rylo...
It's a really excellent solve...

It works...Totally COOL...

Many thanks again Rylo.......many many thanks

regards,
Johan

Excellent Answer...