I tried to utilize the solutions shown here but to no avail.
http://excelforum.com/showthread.php?t=593049
my current formula is =SUMPRODUCT($W2:$W138,H2:H138)
I have 9 buttons assigned to macros to filter in various ways.
They may filter based on Column E or Column F
or![]()
Please Login or Register to view this content.
I would like my SUMPRODUCT to calulate only the filtered data.![]()
Please Login or Register to view this content.
is it possible?
Bookmarks