Excel - Find the Max for Total revenue just for year 1

Question

I am unable to determine the proper formula for calculating the MAX of Total Revenue(E) for Year 1(B) alone.

Could someone please explain this to me?

Answer 1

In Office365 and LibreOffice Calc, there is the MAXIFS function. In the example you provided, a formula that calculates maximal revenue in "Year 1":

=MAXIFS(E2:E308,C2:C308,"Year 1")

In Excel 2016, the problem can be solved by combining MAX and IF in an array formula:

=MAX(IF(C2:C308="Year 1",E2:E308))