**Question description:**

*This user has given permission to use the problem statement for this blog.*

Hi,
I'm trying to count if there was growth in a period and how much time the growth has sustained. So I need to start my count in a values greater than 0 to determine the length of time. My problem is, starting a count on the first negative number in a column determined by time, not counting every positive number in the same time series.

Solved by B. Q. in 25 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
02/05/2018 - 06:03

Hi

Excelchat Expert
02/05/2018 - 06:03

Hi

User
02/05/2018 - 06:03

hi, couldnt answer the last question

Excelchat Expert
02/05/2018 - 06:03

Welcome to Got it Pro

Excelchat Expert
02/05/2018 - 06:03

Can you paste your sample data and let me know your requirement

User
02/05/2018 - 06:04

the yellow determine the first start of growth

User
02/05/2018 - 06:04

i want to learn how to count it instead of selecting it one by one

Excelchat Expert
02/05/2018 - 06:04

Which yellow?

User
02/05/2018 - 06:04

at the bottom

User
02/05/2018 - 06:04

on 2017/04

Excelchat Expert
02/05/2018 - 06:05

Yes

Excelchat Expert
02/05/2018 - 06:05

but how do i read it?

Excelchat Expert
02/05/2018 - 06:05

Please explain

User
02/05/2018 - 06:05

im trying to determine the quarterly grown of every state

User
02/05/2018 - 06:06

starting from the closest quarter

User
02/05/2018 - 06:06

that is 2017/04

Excelchat Expert
02/05/2018 - 06:06

ok

Excelchat Expert
02/05/2018 - 06:06

So?

User
02/05/2018 - 06:06

I want to know the period of time there has been growth

User
02/05/2018 - 06:07

and the only way to count it starting from the closest negative number is one by one

Excelchat Expert
02/05/2018 - 06:07

In cell B2

Excelchat Expert
02/05/2018 - 06:07

there has been growth as it is positive

User
02/05/2018 - 06:07

yes

User
02/05/2018 - 06:07

But the count needs to start from the bottom up sinse its the closest to the present

User
02/05/2018 - 06:07

since*

Excelchat Expert
02/05/2018 - 06:08

why do we need to count only the yellow ones?

User
02/05/2018 - 06:09

so, the yellow ones represent growth, I marked them because I already counted them one by one, what I want you to teach me is how to do it by formula, like count if

User
02/05/2018 - 06:09

the thing is count if would count every positive number in one column

User
02/05/2018 - 06:09

and I want to start counting from the first negative from the bottom up

Excelchat Expert
02/05/2018 - 06:09

Ohk

Excelchat Expert
02/05/2018 - 06:09

Let me see

User
02/05/2018 - 06:12

I know my explanation is confusing im sorry

Excelchat Expert
02/05/2018 - 06:12

Can you arrange this data from recent to alst

User
02/05/2018 - 06:12

yes

Excelchat Expert
02/05/2018 - 06:12

Have put on sheet 2

User
02/05/2018 - 06:14

for example in column B growth start in 2009/04 being B34 and goes till 2017/04

Excelchat Expert
02/05/2018 - 06:18

Can you see the formula that i have created

Excelchat Expert
02/05/2018 - 06:18

Row 58 to row 112

Excelchat Expert
02/05/2018 - 06:18

Do you see?

User
02/05/2018 - 06:18

yes

Excelchat Expert
02/05/2018 - 06:19

So your answer will be the number before first blank

Excelchat Expert
02/05/2018 - 06:19

See and match with previous sheet

Excelchat Expert
02/05/2018 - 06:20

Let me know of that helps

Excelchat Expert
02/05/2018 - 06:20

Are you there?

User
02/05/2018 - 06:20

yes im here

Excelchat Expert
02/05/2018 - 06:21

This is the best method i could think of

User
02/05/2018 - 06:21

we are looking at it, figuring it out thank you

Excelchat Expert
02/05/2018 - 06:21

rather than manually colour coding

Excelchat Expert
02/05/2018 - 06:21

Cool

User
02/05/2018 - 06:23

So, we just extend the formula for all the spaces?

Excelchat Expert
02/05/2018 - 06:23

Since it is on columns there is no way to stop at first blank

Excelchat Expert
02/05/2018 - 06:23

But your answer will be value just before the blank

Excelchat Expert
02/05/2018 - 06:25

Are you able to get it?

User
02/05/2018 - 06:27

yes

User
02/05/2018 - 06:27

thank you, we are gonna copy the formula

Excelchat Expert
02/05/2018 - 06:27

Great

Excelchat Expert
02/05/2018 - 06:27

Cool

Excelchat Expert
02/05/2018 - 06:27

Please do give good rating

Excelchat Expert
02/05/2018 - 06:27

It would really help a lot

User
02/05/2018 - 06:28

sure, we are very grateful have a nice day! :)

Excelchat Expert
02/05/2018 - 06:28

You too have a good day

Excelchat Expert
02/05/2018 - 06:28

:)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*