Summarising/Counting variable data  
Author Message
etchasketch4fun





PostPosted: Mon May 17 02:55:15 CDT 2004 Top

Excel >> Summarising/Counting variable data

I have several very large spreadsheets of data for a family history
project.

I need Excel to be able to tell me how many females (or males or
unknowns) were born or died or married in a particular district and/or
county/state or country between particular time periods.

A rough list would look like this:-

Year Qtr Event Surname Given Names Sex Age District
County Country

1837 3 B EDWARDS John M Maidstone KEN ENG
1837 3 D EDWARDS Mary F U Hollingbourne KEN
ENG
1837 3 M EDWARDS William M U Tenterden KEN
ENG
1837 4 B EDWARDS Zachariah M U Cardiff GLA
WLS

Over the space of the past 167 years, a lot of this data has been
created, and I need to be able to say how many males were born in Kent
[KEN] from 1837 to 1840, 1841-1845, 1846-1850, etc, and the same for
females and unknowns, other counties, specific districts and so forth.

I also need to get an average age at death over these periods and
criteria (where this is provided and is not "U"). Zeros regularly
appear for children who died before they reached the age of 1; they do
not provide the number of weeks, months, days, hours etc in the indexes.
I can sometimes obtain these from other sources, such as burials or
newspapers or headstones, but this is rare.

How do I get Excel to query several columns at the same time to spit out
a single number?

I've tried many permuations of the CountIf function, with no success.
The manual is useless is this respect and so, of course, is "Help".

Your help will be much appreciated, as my project won't be of much use
to me and the greater world if I can't get past this particular hurdle.

Cheers,

H. in Melbourne


** Posted via: http://www.hide-link.com/
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.hide-link.com/ ***

Excel208  
 
 
Frank





PostPosted: Mon May 17 02:55:15 CDT 2004 Top

Excel >> Summarising/Counting variable data Hi
see your other post. In addition you may consider also
using a pivot table for this

>-----Original Message-----
>I have several very large spreadsheets of data for a
family history
>project.
>
>I need Excel to be able to tell me how many females (or
males or
>unknowns) were born or died or married in a particular
district and/or
>county/state or country between particular time periods.
>
>A rough list would look like this:-
>
>Year Qtr Event Surname Given Names Sex
Age District
>County Country
>
>1837 3 B EDWARDS John M
Maidstone KEN ENG
>1837 3 D EDWARDS Mary F U
Hollingbourne KEN
>ENG
>1837 3 M EDWARDS William M U
Tenterden KEN
>ENG
>1837 4 B EDWARDS Zachariah M U
Cardiff GLA
>WLS
>
>Over the space of the past 167 years, a lot of this data
has been
>created, and I need to be able to say how many males were
born in Kent
>[KEN] from 1837 to 1840, 1841-1845, 1846-1850, etc, and
the same for
>females and unknowns, other counties, specific districts
and so forth.
>
>I also need to get an average age at death over these
periods and
>criteria (where this is provided and is not "U"). Zeros
regularly
>appear for children who died before they reached the age
of 1; they do
>not provide the number of weeks, months, days, hours etc
in the indexes.
>I can sometimes obtain these from other sources, such as
burials or
>newspapers or headstones, but this is rare.
>
>How do I get Excel to query several columns at the same
time to spit out
>a single number?
>
>I've tried many permuations of the CountIf function, with
no success.
>The manual is useless is this respect and so, of course,
is "Help".
>
>Your help will be much appreciated, as my project won't
be of much use
>to me and the greater world if I can't get past this
particular hurdle.
>
>Cheers,
>
>H. in Melbourne
>
>
>** Posted via: http://www.ozgrid.com
>Excel Templates, Training, Add-ins & Business Software
Galore!
>Free Excel Forum http://www.ozgrid.com/forum ***
>.
>