Thread
:
Subtotal function for hidden row
View Single Post
#
7
[email protected]
Posts: n/a
={SUM(IF($E$1:$G$10,data,0))} gives the right response. The problem
is that for the each test (A:C) I should have a mirror array (E:G) what
is very inconvenient with big multiworksheets database.
TP,
www.vba.blog.onet.pl
Reply With Quote