ExcelBanter - Formula request

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula request (https://www.excelbanter.com/excel-worksheet-functions/109896-formula-request.html)

I am trying to set up a formula each time the data changes in column A
without having to do it manually.

The formula would be using two other columns of data for the rows involved
with the same company.

e.g.

Column A Column Y

2 Company ABC

3 Company ABC

4 Company ABC =SUM(W2:W4)/SUM(R2:R4)

5 Company def

6 Company def

7 Company def

8 Company def =SUM(W5:W8)/SUM(R5:R8)

9 Company xyz

10Company xyz =SUM(W9:W10)/SUM(R9:R10)

Hi!

Try this:

Enter this formula in Y2:

=IF(A3=A2,"",SUMIF(A$2:A$10,A2,W$2:W$10)/SUMIF(A$2:A$10,A2,R$2:R$10))

Copy down as needed.

Biff

"~~~AAA~~~" wrote in message
...
I am trying to set up a formula each time the data changes in column A
without having to do it manually.

The formula would be using two other columns of data for the rows involved
with the same company.

e.g.

Column A Column Y

2 Company ABC

3 Company ABC

4 Company ABC =SUM(W2:W4)/SUM(R2:R4)

5 Company def

6 Company def

7 Company def

8 Company def =SUM(W5:W8)/SUM(R5:R8)

9 Company xyz

10Company xyz =SUM(W9:W10)/SUM(R9:R10)