Counting of Cells according to several criteria

[Riegsche]

Hey folks,

Product	Size	Date
A	1	1.1.10
A	1	1.2.10
B	1	1.2.10

My table has several thousand rows. I want to have an overall count based on the following rules:

• DON'T count when sizes stay the same, but Products Change
• Count as soon as sizes change; EXCEPT when Product A OR B with size 5 was produced directly before Product C size 4
• Count when there is a gap of GREATER OR EQUAL 2 days between two entries (e.g. 1.1.10 -> next entry is 4.1.10 --> COUNT! )

Is there a formula or function for that purpose?

Thanks in advance for your help.

[jason.b75]

Assuming that your data is in columns A to C, with headers in row 1, data starting in row 2.

In D3 enter this helper formula, then copy it down to the end of your table. (Or a different column if 'D' is already in use).

=OR((C3-c2)>=2,AND(B3<>B2,NOT(AND(B3=4,A3="C",B2=5,OR(C2="A",C2="B")))))+0

Then sum the column with the helper formula to get your count result.