One way using only 3D-enabled formulas:

=AVEDEV(Rng,-SUM(Rng))*(COUNT(Rng)+1)/2+MIN(SUM(Rng),0)

where the name "Rng" refers to "=Week-1:Week-5'!K12".


On 18 Apr, 23:52, Louie wrote:
Hello, I need to write a formula that sums totals from different sheets but,
I want it to ignore the negative numbers and add only the positive #'s

this is what I currently have

=SUM('week-1:Week-5'!K12)

it gives me a negative total because there are some negative numbers in some
cells
thank you for your help!
--
Louie