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