Totaling Different Cell Values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ManBoy86 - 18 Jun 2007 21:59 GMT

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. :)

Reply to this Message

bj - 18 Jun 2007 22:09 GMT

check Subtotal() in help

> 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
[quoted text clipped - 18 lines]
>
> Thanks a bunch for any help. :)

Reply to this Message

Rick Rothstein (MVP - VB) - 18 Jun 2007 22:09 GMT

> I'm having a little trouble figuring out how to total some values. The
> basis
[quoted text clipped - 18 lines]
> that contains the word Total. I was trying to do it with a vlookup but I
> screwed that up.

Give this a try...

=SUMPRODUCT((B1:B100="Total")*(D1:D100))

where I assumed the word "Total" was in column B and the values were in
column D and that the range covered rows 1 thru 100.

Rick

Reply to this Message

T. Valko - 18 Jun 2007 22:09 GMT

Try something like this:

=SUMIF(B1:B10,"Total",C1:C10)

Biff

> I'm having a little trouble figuring out how to total some values. The
> basis
[quoted text clipped - 20 lines]
>
> Thanks a bunch for any help. :)

Reply to this Message

ManBoy86 - 18 Jun 2007 22:20 GMT

Got it. Thanks for the help guys.

Reply to this Message