Calculation MAX of variable reach

[Zazu_0420]

Hey

I am currently trying to calculate how many streams we had each month.

In the file we have some data extracted from Twitch. I column P it tells the number of minutes we have streamed. Those are the columns I wish to show in a chart later on.
Therefor I want to give each stream we did a number in column B. So basically a column B will show if the row is the first or the X' stream of the month.

Each 2 weeks we will download the last 14 days insights from Twitter and add them to the Excel file.

I tried something with a formula I found here on the forum, but that formula gives all the max number of the above cells
Is it possible to add another variable that would take column A (Month) in account?

So the formula would calculate that if P<>0 it would give me the max number (B) of that month (A) and add 1 to that.

Hopefully it is kind of clear what I am trying to do here.

Thanks in advance

[JeteMc]

If I understand correctly then the following yields the desired numbers for column B:

=IF([@[Minuten gestreamd]]<>0,COUNTIFS(A$4:A4,A4,P$4:P4,"<>0"),"")

If this doesn't do what you want, it may help us to know what numbers you want to see in column B as opposed to what numbers the present formula incorrectly yields.
Let us know if you have any questions.

[Zazu_0420]

Thanks!

That indeed worked.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.