Subtotal with ABS

[efernandes67]

Hi,

See the file in attach.

I need a formula that SUMs with ABS the values in a column, ignoring the non values cells.

Regards,
Elio Fernandes

[NBVC]

Will you using autofilter?

If not,

=SUM(IF(ISNUMBER(B6:B16),;BS(B6:B16)))

confirmed with CTRL+SHIFT+ENTER not just ENTER

[NBVC]

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))

[efernandes67]

Thanks for your help. It's working.

Elio