# Excel - IF Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.