Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal multiple entries | Excel Discussion (Misc queries) | |||
subtotal blank cells | Excel Discussion (Misc queries) | |||
Flagging cell entries in a column to add to a subtotal. | Excel Worksheet Functions | |||
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
How to sum subtotal with blank line | Excel Programming |