|
sum only visible cells
Hi, all!
Is there a way to sum just the visible cells in a range? Excel lets one copy or select only visible cells. Can I use an IIF to test a cell is hiden or not then decide if it should be included in the calculation? Thanks! |
sum only visible cells
If by chance, the cells are hidden by a filter, the SUBTOTAL function may
work for you. In a filtered list, the SUBTOTAL function only includes visible cells. Check Excel help for details. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "hommer" wrote: Hi, all! Is there a way to sum just the visible cells in a range? Excel lets one copy or select only visible cells. Can I use an IIF to test a cell is hiden or not then decide if it should be included in the calculation? Thanks! |
sum only visible cells
Are they hidden or filtered? If filtered you can use
=SUBTOTAL(9,Full_range) will sum only visible cells that have been filtered, if they are hidden you can use =SUBTOTAL(109,Full_range) the last function was introduced in Excel 2003 so for previous versions you can't use it so for 97-2002 you need to write a UDF -- Regards, Peo Sjoblom http://nwexcelsolutions.com "hommer" wrote in message ... Hi, all! Is there a way to sum just the visible cells in a range? Excel lets one copy or select only visible cells. Can I use an IIF to test a cell is hiden or not then decide if it should be included in the calculation? Thanks! |
sum only visible cells
What's UDF? How to write a UDF? "Peo Sjoblom" 在郵件 中撰寫... Are they hidden or filtered? If filtered you can use =SUBTOTAL(9,Full_range) will sum only visible cells that have been filtered, if they are hidden you can use =SUBTOTAL(109,Full_range) the last function was introduced in Excel 2003 so for previous versions you can't use it so for 97-2002 you need to write a UDF -- Regards, Peo Sjoblom http://nwexcelsolutions.com "hommer" wrote in message ... Hi, all! Is there a way to sum just the visible cells in a range? Excel lets one copy or select only visible cells. Can I use an IIF to test a cell is hiden or not then decide if it should be included in the calculation? Thanks! |
sum only visible cells
http://makeashorterlink.com/?G5E82181D
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "0-0 Wai Wai ^-^" wrote in message ... What's UDF? How to write a UDF? "Peo Sjoblom" 在郵件 中撰寫... Are they hidden or filtered? If filtered you can use =SUBTOTAL(9,Full_range) will sum only visible cells that have been filtered, if they are hidden you can use =SUBTOTAL(109,Full_range) the last function was introduced in Excel 2003 so for previous versions you can't use it so for 97-2002 you need to write a UDF -- Regards, Peo Sjoblom http://nwexcelsolutions.com "hommer" wrote in message ... Hi, all! Is there a way to sum just the visible cells in a range? Excel lets one copy or select only visible cells. Can I use an IIF to test a cell is hiden or not then decide if it should be included in the calculation? Thanks! |
sum only visible cells
UDF = User Defined Function
Peo Sjoblom's post above links to a page showing how to write one and how to access it in a cell. "0-0 Wai Wai ^-^" wrote: What's UDF? How to write a UDF? "Peo Sjoblom" 礎b繞l瞼籀 瞻瞻翹繞翹g... Are they hidden or filtered? If filtered you can use =SUBTOTAL(9,Full_range) will sum only visible cells that have been filtered, if they are hidden you can use =SUBTOTAL(109,Full_range) the last function was introduced in Excel 2003 so for previous versions you can't use it so for 97-2002 you need to write a UDF -- Regards, Peo Sjoblom http://nwexcelsolutions.com "hommer" wrote in message ... Hi, all! Is there a way to sum just the visible cells in a range? Excel lets one copy or select only visible cells. Can I use an IIF to test a cell is hiden or not then decide if it should be included in the calculation? Thanks! |
| All times are GMT +1. The time now is 08:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com