+ Reply to Thread
Results 1 to 3 of 3

extracting totals from within a spreadsheet

  1. #1
    Jovetta
    Guest

    extracting totals from within a spreadsheet

    I need to know how to take different information from within a spreadsheet
    --where two conditions/catogories must apply so that a third column where i
    have inputed hours, will total for those conditions only... can anyone help?

  2. #2
    Chip Pearson
    Guest

    Re: extracting totals from within a spreadsheet

    I think you need to provide much more detail.


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "Jovetta" <[email protected]> wrote in message
    news:[email protected]...
    >I need to know how to take different information from within a
    >spreadsheet
    > --where two conditions/catogories must apply so that a third
    > column where i
    > have inputed hours, will total for those conditions only... can
    > anyone help?




  3. #3
    Jovetta
    Guest

    Re: extracting totals from within a spreadsheet

    alright, I will try.
    There are columns titled age groups, columns to indicate "hearing person"
    column for "deaf" and two more columns that indicate "working" and "not
    working" (in these two columns i have inputed hours). I need to select a
    certain age group, and break out of the spreadsheet this information, for
    example: age 65, deaf, working...and that total of hours I have worked with
    that catagory. age 65, hearing, working. age 65 hearing not working, and
    finally, age 65 deaf and not working. I need it to total the amount of time
    I spent in all four catagories AND Ideally, it would also total the actual
    number of contacts indicated in the age column, for each category.
    Is this totally confusing?

    "Chip Pearson" wrote:

    > I think you need to provide much more detail.
    >
    >
    > --
    > Cordially,
    > Chip Pearson
    > Microsoft MVP - Excel
    > Pearson Software Consulting, LLC
    > www.cpearson.com
    >
    >
    > "Jovetta" <[email protected]> wrote in message
    > news:[email protected]...
    > >I need to know how to take different information from within a
    > >spreadsheet
    > > --where two conditions/catogories must apply so that a third
    > > column where i
    > > have inputed hours, will total for those conditions only... can
    > > anyone help?

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1