V
Vercingetorix.XIII
Is there a formula that will add a column but ignore the negative numbers???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
=SUMIF(A:A,">0")
S
Sandy Mann
Does:
=SUMIF(A1:A100,">0")
do what you want?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
=SUMIF(A1:A100,">0")
do what you want?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
B
Bernard Liengme
Onlyis you are preapred to have an endless VBA lood recalculating your
worksheet
best wishes
worksheet
best wishes
S
Sandy Mann
You've lost me there Bernard, where does the VBA come in?
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk