Hi all,

I've got a column with a bunch of figures in them. Another column is
often autofiltered and I've found that SUBTOTAL seems to be a good
function to sum the figures when the autofilter is on.

However, and it seems to have happened all of a sudden (I'm sure it
used to work!), my cell is now showing a #VALUE! error message due to a
number of the same error message in a number of the cells in the column.
I've tried to experiment with ISNUMBER and ISERROR formulas to overcome
this, but no joy as of yet. Can anyone suggest a formula that will
work. FYI - my subtotal formula is:

=SUBTOTAL(9,L3:L351)

TIA,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=548971