| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum only visible cells
Is there a formula to sum only visible cells, so that if I hide a row the
formula result will change? (In B6) =SUMIF(A1:A5,NOT( [cell row hidden] ),B1:B5) Or will I need to write a function to do this? TIA Charlie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
| Sum visible cells only | Excel Discussion (Misc queries) | |||
| Sum of visible cells only | Excel Worksheet Functions | |||
| can i sum up only visible cells? | Excel Worksheet Functions | |||
| Help: Copying Visible Cells only to Visible cells! | Excel Programming | |||
Threaded Mode
