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.