| 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 | |||
Linear Mode
