# Count Values Less Than Zero

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

• Hi all,

I have a little formula problem, I am using and index and match formula to find what date the value is less than zero. However I am not using a continous time series in my figures but a time span for example 2008-01-30 - 2008-02-05. The formula works fine with a continous time series but not for time spans. Does anyone have a clue to get round this. I am enclosing an example where the formula works and also an example where it does not.
Grateful for any help!

Robert

## Files

.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

• Re: Matching Date Where Value Is Less Than Zero

I can't figure out what your formula is supposed to return in the context of the workbook.

[SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

• Re: Matching Date Where Value Is Less Than Zero

Ie number of days with positive Cash Flow.
//Robert

.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

• Re: Matching Date Where Value Is Less Than Zero

[COLOR="Blue"]=COUNTIF(B10:K10, ">0")[/COLOR]

[SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

• Re: Matching Date Where Value Is Less Than Zero

Quote from shg

[COLOR="Blue"]=COUNTIF(B10:K10, ">0")[/COLOR]

Well that's all nice and well if you have a linear time axis. However I do not, so that will not work I am afraid. I have toyed with the idea of using an IF statement to find if the length of the date cell is >10 then it should use a right formula and use the 10 right letters. Hope you understand what I mean. If you check the spreadsheet, I basically want the formula that is #N/A to show the same as the formula that has a value (except for number of dayes and date of course).
Robert

.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

• Re: Count Values Less Than Zero

Sorry, I just can't tell what you're trying to do with the data that's in your sheet.

[SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!