Thank you. It worked when I did it in the sample. I got 120 this time. The only thing is I cannot use #this row because I have all my reporting on one worksheet. I want it to be able to total on a separate worksheet. If I use this row it has to be in the main document.