How do I add up row sums in a systematic manner?

W

wicked_rich

I am trying to add up the sums of various rows in a systematic manner. To
clarify, in my spreadsheet I have data in rows on the number of people who
fall into single age categories (ages 18-24), by state. I'd like to summarize
the data for each state. That is, let's say there are 1,000 people in Alaska
who are age 18, age 19, age 20, age 21, age 22, age 23, and age 24. I'd like
to find a function (across all states) that would produce a row that would
summarize, "There are 7,000 people in Alaska between 18-24 years of age"
without doing this for each set of rows for each state. Please advise.
 
T

Tom Ogilvy

Possibly a pivottable could give you such summarization although it won't
write out a sentence for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top