# COUNTIF calculated values without filling them to cells [closed]

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...

Thanks for input!

edit retag reopen merge delete

### Closed for the following reason question is not relevant or outdated by Alex Kemp close date 2020-09-29 23:42:09.953114

Sort by » oldest newest most voted

Hello? No one with an idea?

EDIT: First of all, this link works much better! :) https://www.dropbox.com/s/theitapov8a...

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.

more

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.

( 2017-04-18 12:45:46 +0100 )edit

Thanks for the hint!

( 2017-04-19 11:20:53 +0100 )edit