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