Spreadsheet: 182748d1348590565-countifs-formula-example
Sheet: Sheet1

1) Based on the data provided below, tally the number of people born in each month.  Then create a graph illustrating the results by month and provide at least one observation on the data.
2)  Using formulas, determine how many people have names beginning with "J" and were also born in a month that begins with "J."
Name | Date of Birth | Month | Name | Month |  | Month | Month Name | Tally
[NAME] | 1962-02-10 00:00:00 | 2 |  |  |  | 1 | Jan
[NAME] | 1961-08-12 00:00:00 | 8 |  |  |  | 2 | Feb
[NAME] | 1971-06-11 00:00:00 | 6 |  |  |  | 3 | Mar
Dolores | 1970-03-06 00:00:00 | 3 |  |  |  | 4 | Apr
Eva | 1972-08-23 00:00:00 | 8 |  |  |  | 5 | May
[NAME] | 1972-04-25 00:00:00 | 4 |  |  |  | 6 | Jun
[NAME] | 1944-03-21 00:00:00 | 3 |  |  |  | 7 | Jul
Nicole | 1962-12-17 00:00:00 | 12 |  |  |  | 8 | Aug
[NAME] | 1955-07-09 00:00:00 | 7 |  |  |  | 9 | Sep
[NAME] | 1954-06-07 00:00:00 | 6 |  |  |  | 10 | Oct
[NAME] | 1964-09-15 00:00:00 | 9 |  |  |  | 11 | Nov
[NAME] | 1944-02-07 00:00:00 | 2 |  |  |  | 12 | Dec
[NAME] | 1945-05-02 00:00:00 | 5
Melvin | 1933-04-15 00:00:00 | 4 |  |  |  |  |  |  |  |  | Number of people with names beginning in J and born in J months
[NAME] | 1944-12-01 00:00:00 | 12
[NAME] | 1954-03-28 00:00:00 | 3
[NAME] | 1960-07-27 00:00:00 | 7
[NAME] | 1947-06-11 00:00:00 | 6
[NAME] | 1956-05-13 00:00:00 | 5
[NAME] | 1963-04-09 00:00:00 | 4
[NAME] | 1960-10-19 00:00:00 | 10
[NAME] | 1960-09-12 00:00:00 | 9
[NAME] | 1956-10-30 00:00:00 | 10
Fred | 1960-01-03 00:00:00 | 1
George | 1964-01-24 00:00:00 | 1
[NAME] | 1961-12-28 00:00:00 | 12
Eleanor | 1958-09-07 00:00:00 | 9
[NAME] | 1951-02-27 00:00:00 | 2
[NAME] | 1979-10-16 00:00:00 | 10
[NAME] | 1959-12-15 00:00:00 | 12
[NAME] | 1956-10-28 00:00:00 | 10
[NAME] | 1954-07-30 00:00:00 | 7
[NAME] | 1958-07-29 00:00:00 | 7
Sonja | 1951-10-06 00:00:00 | 10
[NAME] | 1956-07-02 00:00:00 | 7
Beverly | 1971-01-02 00:00:00 | 1
[NAME] | 1956-09-06 00:00:00 | 9
[NAME] | 1960-09-16 00:00:00 | 9
Carol | 1971-04-02 00:00:00 | 4
[NAME] | 1949-06-25 00:00:00 | 6
[NAME] | 1978-10-30 00:00:00 | 10
[NAME] | 1945-10-24 00:00:00 | 10
[NAME] | 1962-10-24 00:00:00 | 10
[NAME] | 2004-08-16 00:00:00 | 8
[NAME] | 1963-08-26 00:00:00 | 8
[NAME] | 1954-02-02 00:00:00 | 2
Lewis | 1966-05-26 00:00:00 | 5
[NAME] | 1966-11-09 00:00:00 | 11
[NAME] | 1933-02-22 00:00:00 | 2
Theodore | 1974-09-16 00:00:00 | 9
Kathy | 1935-12-31 00:00:00 | 12
[NAME] | 1970-07-07 00:00:00 | 7
[NAME] | 1958-02-18 00:00:00 | 2
[NAME] | 1948-12-13 00:00:00 | 12
[NAME] | 1939-03-24 00:00:00 | 3
Kiley | 1969-01-29 00:00:00 | 1
Adella | 1955-12-18 00:00:00 | 12
[NAME] | 1942-07-08 00:00:00 | 7
Theodore | 1953-05-16 00:00:00 | 5
[NAME] | 1965-08-23 00:00:00 | 8
Daryl | 1937-08-28 00:00:00 | 8
Coral | 1961-11-11 00:00:00 | 11
[NAME] | 1950-04-23 00:00:00 | 4
Shawn | 1958-03-05 00:00:00 | 3
[NAME] | 1965-10-07 00:00:00 | 10
[NAME] | 1962-08-02 00:00:00 | 8
Anne | 1947-10-29 00:00:00 | 10
[NAME] | 1962-05-18 00:00:00 | 5
[NAME] | 1952-05-04 00:00:00 | 5
[NAME] | 1972-03-21 00:00:00 | 3
Julia | 1969-10-15 00:00:00 | 10
[NAME] | 1953-05-24 00:00:00 | 5
[NAME] | 1963-12-29 00:00:00 | 12
[NAME] | 1931-10-28 00:00:00 | 10
[NAME] | 1960-10-11 00:00:00 | 10