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?
Jan 8 in Others 41 views

## 1 answer to this question.

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))`
• 60,820 points

## Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

## How do you calculate the Quintile for groups of rows in Excel?

Use this formula: =MAX(1,ROUNDUP(10*PERCENTRANK(\$C:\$C,\$C2,4),0)) To divide into whichever many ...READ MORE

## Large excel file, I'm trying to find duplicates and copy the rest of the cells across the duplicate to the duplicate it finds

Copy the column from the other sheet ...READ MORE

## Find max and second max salary for a employee table MySQL

SELECT MAX(SALARY) FROM Employee WHERE SALARY < ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE