COUNTIF calculated values without filling them to cells

Hi folks!

For the “profit” column (B), I’d need to count the values between 0 and 36 (exclusively) in the “win days” column (G), but as if they were calculated from A-D rather than NOW()-D. Maybe the solution of this question could also help here, but I don’t get to it…

Here is the link: Dropbox - File Deleted

Thanks for input!

Hello? No one with an idea?

First of all, this link works much better! :slight_smile:

In column B, I’d like to have the number of investments in their win days at the respective day in column A. An investment is in its win days for 35 days after the risk days. F.e. for A value 04/11/17 (01/01/17 + 100) the B value should be 2 beause of 2 running investments in win days.

Deever: “Hello? No one with an idea?”

Would you mind to rework your question in a way that someone contributing here might understand it. I tried but didn’t.
In cases where the wording of an intention was tried hard but doesn’t seem to be undoubtably clear, it is often helpful to additionally list some expected results. Example: “I want to get (e.g.):
B3 = 17
B4 = 11

B11= 21”
Please, do not rely on the examples alone.

Thanks for the hint!