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" ¦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!