Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional sum
Hi!
I use the formula =Sum("A1:A100") to perform a sum. However the user can filter the data and then I want the formula to only perform the sum on the filtered data (visible data). How do I write this formula? Regards PO |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |