Totaling Different Cell Values
check Subtotal() in help
"ManBoy86" wrote:
I'm having a little trouble figuring out how to total some values. The basis
of the worksheet is that I have different sections that each have a tota
valuel but then I want to find the overall total of all the sections' totals.
This is the basis of it
------ $
------ $
------ $
Total X
------ $
------ $
------ $
Total X
Overall Total ?
I want to add all the x's but not do it manually, I want it to search for
the word Total and add up all the values of the cell across from any cell
that contains the word Total. I was trying to do it with a vlookup but I
screwed that up.
Thanks a bunch for any help. :)
|