0 votes
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, 2023 in Others 286 views

## 1 answer to this question.

0 votes

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))`
answered Jan 8, 2023 by
• 63,720 points

0 votes
1 answer

## 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

0 votes
1 answer

## 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

0 votes
1 answer

## 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

0 votes
1 answer

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

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

0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

0 votes
1 answer

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

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

0 votes
0 answers

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

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

0 votes
1 answer

## IF - ELSE IF - ELSE Structure in Excel

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

0 votes
1 answer

## What is the max length of page titles for SEO?

google displays only 50-60 words of a ...READ MORE

0 votes
1 answer

## Why is just an ID in the URL path a bad idea for SEO?

yes it affects the click through rates ...READ MORE