Count number of days when sales first reached 100 units

[centurion87]

Hi guys,
am new to excel and I need advice of someone more expirienced than myself.
I have large excel table and need to count number of days when sales first time reached 100 units of product but not to count blanks and if there were more sales on the same date it should be counted as one day (obviously)
My table has multiple rows that include date, product colum for each product where I put quantities and buyer.

Can someone help me out with formula for my problem?

[BMV]

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results.

It is necessary in your case.

[centurion87]

here it is

[centurion87]

does anyone know solution to this problem?

[BMV]

Can you replace file, add some extra rows and show the result. 100 units - is it both Kilo and Liter?

[centurion87]

Can you replace file, add some extra rows and show the result. 100 units - is it both Kilo and Liter?

I can't am afraid. For this example it is bread in kilos lets say.

[BMV]

I hope additional column enough for you. Filter for non blank value and buyer show the result.
The other variant will be very dificalt and hard for calculation. For example I sowed only part.

[centurion87]

I hope additional column enough for you. Filter for non blank value and buyer show the result.
The other variant will be very dificalt and hard for calculation. For example I sowed only part.

I thank you for your effort.

Maybe I didn't articulate the problem good enough.
What I need is the number of days when sales hit 100 units or more (1 day, 5 days or something)
the correct result in this example is 2 days
and I don't want formula to count blanks and sales that are on the same day are 1 day (c2+c3 =31 kg on 5.11.2019)

[BMV]

array formula

Please Login or Register  to view this content.

[centurion87]

it says: the syntax of this name isn't correct

[BMV]

Take from the file or try to replace ";" to ",".

[centurion87]

Take from the file or try to replace ";" to ",".

no luck so far am affraid

[BMV]

Did you open the file from #9? It is working?
14-01-2020 23-12-51.jpg