It should total on one worksheet the values on another worksheet. Are you
asking to total across worksheets rather than what I described here? If so,
what sheets are you referring to as your original email said nothing of
that.

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
ups.com...
Thank you for your assistance. The formula above still does not appear
to work across multiple worksheets. For example, when I use exactly
what you have above in single worksheet, it works.

However, when I have the totals (the F & G columns above) on a
different worksheet, it keeps returning a "0".

Any ideas? The data worksheet has a lot more columns of data than my
example above, so I have all of my total caculations on a different
worksheet.