Subtotal on cell with blank entries
I have a spreadsheet like
Name Price
name1 100
20
name2 200
name3 100
100
10
Can I write a formula that will give me a subtotal in column C
such as
Name Price Total
name1 100
20 120
name2 200 200
name3 100
100
10 210
Thanks!
|