Hi,

I need to count the number of times a test is analyzed where one should only count new cases at 1 month intervals for each patient.

See attached image.

The X’s are only there to illustrate which rows I want to count.

I have tried using an if-formula but to no success.

Hope there is someone who can help with this

I need to count the number of times a test is analyzed where one should only count new cases at 1 month intervals for each patient.

See attached image.

The X’s are only there to illustrate which rows I want to count.

I have tried using an if-formula but to no success.

Hope there is someone who can help with this