Ask Your Question

COUNTIF calculated values without filling them to cells [closed]

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

Deever gravatar image

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

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:

Thanks for input!

edit retag flag offensive 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

1 Answer

Sort by » oldest newest most voted

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

Deever gravatar image

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

Hello? No one with an idea?

EDIT: First of all, this link works much better! :)

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


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 +0100 )edit

Thanks for the hint!

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

Question Tools

1 follower


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

Seen: 41 times

Last updated: Apr 19 '17