Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
IF AND FORMULA REQUEST | Excel Discussion (Misc queries) | |||
Here is a simple formula request from a newb | Excel Worksheet Functions | |||
Request To Shorten A Formula | New Users to Excel | |||
Another Date Formula Request | Excel Worksheet Functions |