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?

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" wrote in message
...
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?

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" wrote in message
...
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?