Professor Excel

Comments 4

  1. Ingrid

    Is there a way to combine SUMIF or SUMIFS to this to allow for multiple entries. For example if Canada had two rows?

  2. Nikunj Parasrampuria

    Very educating and useful article. In-depth and detailed explanation from every aspect where a person is most likely to make a mistake. Helped me big time. Thanks.

    PS: It worked for me after pressing CTRL + SHIFT + ENTER, didn’t work with just ENTER, a necessary step for the formula it seems. If it helps I used the Method 4. Maybe this information should be a part of the article as well, I maybe wrong though. Did anyone go through the issue as me?

Leave a comment

%d bloggers like this: