how to do sum using vba when meet an empty row

M

mango

dear all, how to sum up the total for each of the category below in vba? when
next row is empty then can do a sum up. for example a shell and head will be
4650 when encounter an empty row after linda.
can help. thanks


a shell and head
andy 50
sussy 100
linda 4500

b nozzle
james 98
zortan 340

c manhole
bryan 34
fendi 444
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to do sum when meet an empty line in vba 1
Crosstab: Sum of Columns over Row 2

Top