Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total a column in which there are sum formula
I have a column in which I have given for sub total the sum formula that
=sum(F6..F8), like this there are several of them in that column. However at the bottom of the column I want the total of the column excluding the cells that have the formula =sum How can I do that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for average of a top 12 numbers in a column of 24 total nu | Excel Discussion (Misc queries) | |||
FORMULA; ADD A COLUMN, SUBTRACT 1 CELL, TAKE THE TOTAL X 10% | Excel Discussion (Misc queries) | |||
Formula to add top 4 entries in a column and total them at the bot | Excel Worksheet Functions | |||
XL formula - total of row = total of column | Excel Worksheet Functions | |||
Create an if-then formula in Excel to limit column total? | Excel Discussion (Misc queries) |