Max of a certain Criteria

Hi there, If I am trying to find the maxiumum value of all cells that fit a certain criteria what formula could I use? For example, lets say I have 10 rows of data. that either fit Criteria A, Criteria B, or Criteria C. If I want to find the make value of all values that fit Criteria B, how would I calculate that in excel?

By: Sarah

Leave a Reply

Your email address will not be published. Required fields are marked *