I'm having the following problem:

If text values are similar in Column B then gather $$ values found in Column M and display the mean of those fields in Column N.

closed as unclear what you're asking by Rubén, Eight Days of Malaise, ale, serenesat, jonsca Nov 1 '16 at 0:46

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Do realise, that the problem you described has nothing to do a script or conditional formatting. – Jacob Jan Tuinstra Oct 3 '13 at 19:35
  • @Tina: What do you mean by similar? – Rubén Oct 31 '16 at 13:25

Use the following formula to accomplsh this.




The UNIQUE function will get the unique entries. The SUMIF will sum M:M if one of the entries, given by the UNIQUE formula, matches in B:B.


I've created an example file for you: SUMIF range

Not the answer you're looking for? Browse other questions tagged or ask your own question.