Share via

SUM Question...

Anonymous
2023-03-15T03:52:04+00:00

Dearest Wizards,

A1-A195 is a list of all of the countries in the world.

B1-B195 is the population of each of those countries

C1-C195 is a non-sequential and non-repeating but complete list of the 44 countries of Europe

What formula can I put in D1 that will give me the total population of those 44 European countries?

TIA,

Sam

Microsoft 365 and Office | Excel | Other | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-16T14:07:46+00:00

    Hi SamBeardsley!

    Thank you for the feedback

    You may need to state the countries in the formula.

    Please try the two formulas below: 

    1.  =SUMIF(A1:A195, OR(C1="Italy",C1="France",C1="Switzerland",C1="Spain",C1="etc"), B1:B195)

    This formula uses the OR function to check whether each cell in the range C1:C195 matches any of the European countries in the criteria list. If a match is found, the corresponding value from the range B1:B195 is added to the sum. Note that you can adjust the list of European countries in the formula to include any additional countries that you need to include.

    1. =SUMIF(A1:A195,C1:B195)

    This formula will sum the population of all the countries in B1:B195 that match any of the countries listed in C1:C195.

    Kindly let me know, if you require additional assistance, I will be glad to help further.

    Best Regards, Shakiru

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-03-16T13:21:58+00:00

    Hi Shakiru,

    This isn't quite what I was looking for, and I may not have been clear enough in my original question.

    None of the entries in Col C are the word "Europe" but rather 'Italy', 'France', 'Switzerland', 'Spain' etc.

    Thank you for entertaining this question,

    Sam

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-03-15T05:31:16+00:00

    Hi SamBeardsley!

    I am Shakiru, an independent advisor and a user like you, and I am glad to be helping you out today.

    You can use the SUMIF function to calculate the total population of the 44 European countries. Here's the formula you can use:

    =SUMIF(C1:C195,"Europe",B1:B195)

    This formula will sum the population of all the countries in the range B1:B195, but only for the ones that have "Europe" in the corresponding cell in the range C1:C195.

    Kindly let me know, if you require additional assistance, I will be glad to help further.

    Best Regards, Shakiru

    Was this answer helpful?

    0 comments