Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 8th 18, 07:05 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2018
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!

  #2   Report Post  
Old August 9th 18, 07:24 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 45
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


Something like this might help.

Put the following in C2 and copy down
=IF(A2&B2="","",
IF(OR(A3<"",A3&B3=""),
SUM(B$1:B2)-SUM(C$1:C1),
""))


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotal multiple entries MAD101 Excel Discussion (Misc queries) 1 October 21st 08 01:57 AM
subtotal blank cells The Rook[_2_] Excel Discussion (Misc queries) 2 September 19th 08 01:16 AM
Flagging cell entries in a column to add to a subtotal. Scott Excel Worksheet Functions 2 April 6th 08 05:10 PM
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... [email protected][_2_] Excel Programming 2 June 7th 07 09:27 PM
How to sum subtotal with blank line hon123456 Excel Programming 1 September 14th 06 04:10 AM


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017