H
HAJ
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 ***
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 ***