View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Monarch TicketOffice Monarch TicketOffice is offline
external usenet poster
 
Posts: 1
Default 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!