These should show in column C under Volume.

Failed Tot = 6
Invalid Tot = 9
Success Tot = 21

Howard

In this case, where the structure is not consistent, a helper column is
needed (IMO)! That's what I use on 'Summary' since subaccounts for any
account will usually not be the same number of values. Also,
col-absolute/row-relative defined names are used. So technically, the
sheet is a structured template by design. But then, that's my standard
approach to most projects anyway and so isn't anything new to me!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion