I have a column of numbers - both positive and negative this is also on Auto Filter. I have the formula to total only the filtered lines, however, I can not get the formula to add only positive numbers within the filter. I must leave the negatives in the sort for integrity purposes. Any help would be great!