sum cells based on contents of adjacent cell (validated list)?

C

Casi12

I have 2 columns. Col A is a data validated list containing country names.
Col B is a list of numbers (eg English 6, French 9 etc on several rows). I
have one worksheet per day of the month. What formula do I use to sum all all
of column B against the relevant language so that I can see a summary of the
total for each country per day?
 

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