Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a monthly table where the no. of rows varying from month to month i want to make a sum of the sells depends on the condition that the next cell is not empty, and if the cell is empty I want to start a new calculation for the next cells
Solved by I. H. in 43 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/02/2018 - 05:19
Hi
Excelchat Expert 24/02/2018 - 05:19
how may i help you?
User 24/02/2018 - 05:19
Hi
Excelchat Expert 24/02/2018 - 05:20
can you paste the data?
User 24/02/2018 - 05:20
I don't have the data now
Excelchat Expert 24/02/2018 - 05:20
that will help me understand the question
User 24/02/2018 - 05:20
can I work on the sheet next to chat
Excelchat Expert 24/02/2018 - 05:21
yes
User 24/02/2018 - 05:24
the rows are variable from month to month
Excelchat Expert 24/02/2018 - 05:25
show some more sample data to work on
User 24/02/2018 - 05:26
I want to sum the C cells if it is not blanc
User 24/02/2018 - 05:27
and when it is blanc I want to start a new formula
User 24/02/2018 - 05:30
this is the final result I want
User 24/02/2018 - 05:31
but the rows are not same each month
User 24/02/2018 - 05:31
so I need to have a formula to sum the cells up to an empty cell
User 24/02/2018 - 05:32
where a new sum should start for the bellow cells
User 24/02/2018 - 05:32
up to an empty cell
Excelchat Expert 24/02/2018 - 05:33
see the formula
User 24/02/2018 - 05:34
check the second sheet please
Excelchat Expert 24/02/2018 - 05:34
it counts values from c5 50 c100 till where it is non zero
User 24/02/2018 - 05:34
If i will paste the numbers
Excelchat Expert 24/02/2018 - 05:35
see the formula
Excelchat Expert 24/02/2018 - 05:35
index match will be used
User 24/02/2018 - 05:37
Thanks
Excelchat Expert 24/02/2018 - 05:37
does this help?
Excelchat Expert 24/02/2018 - 05:37
let me know
User 24/02/2018 - 05:37
it is not working on D1
Excelchat Expert 24/02/2018 - 05:37
no number on d1
Excelchat Expert 24/02/2018 - 05:38
but this works
Excelchat Expert 24/02/2018 - 05:38
use c1 there
Excelchat Expert 24/02/2018 - 05:38
not c2
Excelchat Expert 24/02/2018 - 05:38
see
Excelchat Expert 24/02/2018 - 05:38
now it works for c1 as well
Excelchat Expert 24/02/2018 - 05:38
d you see
Excelchat Expert 24/02/2018 - 05:38
do you see?
User 24/02/2018 - 05:39
not really
Excelchat Expert 24/02/2018 - 05:39
in sheet 2
Excelchat Expert 24/02/2018 - 05:39
i hv pasted the formula
User 24/02/2018 - 05:39
I thanks
Excelchat Expert 24/02/2018 - 05:40
please do give good rating
Excelchat Expert 24/02/2018 - 05:40
that really helps
User 24/02/2018 - 05:40
sure
Excelchat Expert 24/02/2018 - 05:40
thanks a lot
User 24/02/2018 - 05:40
thank you
Excelchat Expert 24/02/2018 - 05:40
welcome
User 24/02/2018 - 05:40
how to rate
Excelchat Expert 24/02/2018 - 05:41
when it comes to you just give 5 star rating
Excelchat Expert 24/02/2018 - 05:41
i think when the time ends
User 24/02/2018 - 05:52
how can I reach the end result as shows
User 24/02/2018 - 05:52
can I do it in one formula
Excelchat Expert 24/02/2018 - 05:52
which result
User 24/02/2018 - 05:52
sheck sheet 2 please
User 24/02/2018 - 05:53
when cell C is empty
User 24/02/2018 - 05:53
i want the formula to work
User 24/02/2018 - 05:54
when it is not ""
Excelchat Expert 24/02/2018 - 05:54
it is showing as 5
User 24/02/2018 - 05:54
if i want to drag it to the D100
User 24/02/2018 - 05:54
and only want it to calculate when C is emply
User 24/02/2018 - 05:55
for the next C cells
Excelchat Expert 24/02/2018 - 05:56
see the new formula in d1
Excelchat Expert 24/02/2018 - 05:56
i have dragged it down
Excelchat Expert 24/02/2018 - 05:57
it will only show values against blank row and will summ till non zero value
Excelchat Expert 24/02/2018 - 05:57
hope this helps
User 24/02/2018 - 05:57
perfect
User 24/02/2018 - 05:57
this is what I was looking for
Excelchat Expert 24/02/2018 - 05:57
cool

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc