LinkBack URL
About LinkBacks
or use, which works with filtered and unfiltered list and does not need CSE confirmation:
=SUMPRODUCT(ABS(SUBTOTAL(9;OFFSET(B6:B16;ROW(B6:B16)-MIN(ROW(B6:B16));;1)));--ISNUMBER(B6:B16))
or use, which works with filtered and unfiltered list and does not need CSE confirmation:
=SUMPRODUCT(ABS(SUBTOTAL(9;OFFSET(B6:B16;ROW(B6:B16)-MIN(ROW(B6:B16));;1)));--ISNUMBER(B6:B16))
Last edited by NBVC; 06-08-2010 at 11:29 AM. Reason: changed commas to semi-colons
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks