Remember Me?

#1
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
Subtotal on cell with blank entries

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
August 9th 18, 07:24 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Dec 2012 Posts: 47
Subtotal on cell with blank entries

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),
""))

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post MAD101 Excel Discussion (Misc queries) 1 October 21st 08 01:57 AM The Rook[_2_] Excel Discussion (Misc queries) 2 September 19th 08 01:16 AM Scott Excel Worksheet Functions 2 April 6th 08 05:10 PM [email protected][_2_] Excel Programming 2 June 7th 07 09:27 PM hon123456 Excel Programming 1 September 14th 06 04:10 AM

All times are GMT +1. The time now is 05:42 PM.