use subtotal(9,range)

on the sunif to ignore hides rows

HTH
regards from Brazil
Marcelo

"muchacho" escreveu:


Does this function ignore invisible cells (autofilter) ?

If not, what could be an alternative?


--
muchacho
------------------------------------------------------------------------
muchacho's Profile: http://www.excelforum.com/member.php...o&userid=35082
View this thread: http://www.excelforum.com/showthread...hreadid=555662