Spreadsheet: 182746d1348589897-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 | 4
[NAME] | 1961-08-12 00:00:00 | 8 |  |  |  | 2 | Feb | 6
[NAME] | 1971-06-11 00:00:00 | 6 |  |  |  | 3 | Mar | 6
Dolores | 1970-03-06 00:00:00 | 3 |  |  |  | 4 | Apr | 5
Eva | 1972-08-23 00:00:00 | 8 |  |  |  | 5 | May | 7
[NAME] | 1972-04-25 00:00:00 | 4 |  |  |  | 6 | Jun | 4
[NAME] | 1944-03-21 00:00:00 | 3 |  |  |  | 7 | Jul | 7
Nicole | 1962-12-17 00:00:00 | 12 |  |  |  | 8 | Aug | 7
[NAME] | 1955-07-09 00:00:00 | 7 |  |  |  | 9 | Sep | 6
[NAME] | 1954-06-07 00:00:00 | 6 |  |  |  | 10 | Oct | 13
[NAME] | 1964-09-15 00:00:00 | 9 |  |  |  | 11 | Nov | 2
[NAME] | 1944-02-07 00:00:00 | 2 |  |  |  | 12 | Dec | 8
[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 |  |  | Observation
[NAME] | 1978-10-30 00:00:00 | 10 |  |  | The month with the highest number of births is October with 13. The next month,
[NAME] | 1945-10-24 00:00:00 | 10 |  |  | November, has the lowest number of births with 2.
[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 |  |  | 1
Lewis | 1966-05-26 00:00:00 | 5 |  |  | 6
[NAME] | 1966-11-09 00:00:00 | 11 |  |  | 7
[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