sum visible amounts

[rumkus]

My cols (a,b,c,d) date, in, out, amount. Filter on cols a,b,c.
When filtered how can i sum only negative amounts or positive amounts
on col (d) ?
By vba or formula ?
Many thanks in advance.

 

[Don Guillett]

My cols (a,b,c,d) date, in, out, amount. Filter on cols a,b,c.
When filtered how can i sum only negative amounts or positive amounts
on col (d) ?
By vba or formula ?
Many thanks in advance.

http://blog.contextures.com/archive...n-friday-subtotal-and-sumproduct-with-filter/

 

[rumkus]

Thank you very much Don.
Fool of me neglecting Debra's site lately.
Kind regards