Ask Your Question
0

COUNTIF calculated values without filling them to cells

asked 2017-04-13 14:07:55 +0200

Deever gravatar image

updated 2017-04-13 14:19:52 +0200

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: https://www.dropbox.com/s/theitapov8a...

Thanks for input!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-04-18 10:02:09 +0200

Deever gravatar image

updated 2017-04-19 11:19:57 +0200

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.

edit flag offensive delete link more

Comments

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.

Lupp gravatar imageLupp ( 2017-04-18 12:45:46 +0200 )edit

Thanks for the hint!

Deever gravatar imageDeever ( 2017-04-19 11:20:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-13 14:07:55 +0200

Seen: 30 times

Last updated: Apr 19 '17