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

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?

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

Maybe:

=SUMIF(A1:A10,"English",B1:B10)

HTH,
Paul

--

"Casi12" wrote in message
...
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?

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

That worked! Thank you so much:)

"PCLIVE" wrote:

Maybe:

=SUMIF(A1:A10,"English",B1:B10)

HTH,
Paul

--

"Casi12" wrote in message
...
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?

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

You're welcome.

--

"Casi12" wrote in message
...
That worked! Thank you so much:)

"PCLIVE" wrote:

Maybe:

=SUMIF(A1:A10,"English",B1:B10)

HTH,
Paul

--

"Casi12" wrote in message
...
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?