If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula request
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) |
#2
|
|||
|
|||
Formula request
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) |
Thread Tools | |
Display Modes | |
|
|