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?
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?
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?
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?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks