i can't seem to get anything to work.

the data appears as follows:


Code:
--------------------

A B
ON 1000
ON 1000
OFF 500
OFF 500
ON 1000
OFF 1000
OFF 400
OFF 300
ON 400

--------------------


now, i have an autofilter that will filter some of these out and leave
the rest, e.g.:


Code:
--------------------

A B
OFF 500
OFF 500
ON 1000
OFF 1000
ON 400

--------------------


now i need to calculate a sum with the condition that the value in
column a is "on". here, the answer should be 1400.

the usual array formula with a sum doesn't work because it sums hidden
cells as well. the only function i know of that sums correctly is the
subtotal function, but i don't know how to add the "on"-only condition
to it.

any ideas? thanks.


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=572446