Hi Bob,

I have type without test, and when I have tried it doesn't work here,
course I did something bad, if you say it works. It works.

Regards and thanks for the feedback
Marcelo



"Bob Phillips" escreveu:

what makes you think it doesn't?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Marcelo" wrote in message
...
SORRY IT'S DOESN'T WORK
MARCELO

"Marcelo" escreveu:

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