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

  • Thread starter Thread starter Casi12
  • Start date Start date
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?
 
Back
Top