Later on this same evening I found the answer was to use the SUM Function but as an array formula. It took me a while to sort it out. The webpage which helped me was here.
I have been looking at household sizes today. I was able to produce two charts on the 1861 census page using Excel and the COUNTIF function. I have not yet been able to count automatically (I could do it manually) the number of sons and daughters in each household. There has to be a way!
Later on this same evening I found the answer was to use the SUM Function but as an array formula. It took me a while to sort it out. The webpage which helped me was here.
0 Comments
Your comment will be posted after it is approved.
Leave a Reply. |
WelcomeSee the Home page for details of this site. Comments will be moderated. Archives
December 2023
|