Most valuable professional
  • Hot Topics

Excel Help with Sumifs

Good Day I am busy with an ambitious project. I have obtained data of all first names registered in al US states from 1910 to 2014. The data is simply too much to be able to use one sheet only. What I have done is to have all the 51 states in its own sheet. The data contains names, sex, year and total count of names. The sheets are sorted by year and name occurrences I created a unique list of all the names in a new sheet and created a matrix with names running down and years running across. The unique number of names is a list of 30255 first names sorted alphabetically. I created named ranges as follows for all states from the sheets: Wyoming WY WY_Sex WY_Year WY_Name WY_No West Virginia WV WV_Sex WV_Year WV_Name WV_No Wisconsin WI WI_Sex WI_Year WI_Name WI_No etc. I tried to populate my matrix with the following formula:

This question generated 16 answers. To proceed to the answers, click here.

This thread is current as of November 24, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel