Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Criscristina92
 | Femeie
25 ani
Bucuresti
cauta Barbat
29 - 80 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 17 ani
Postari: 2186
|
|
Source:
The user had a sheet with 2 drop down lists, both for start month ranging from Jan to Dec, 1 located in F3 and the other in F4 (see image below).
He also had a range with 3 targets arranged vertical as row names F8:F10 and months Jan to Dec in range G7:R7.
There were some numbers for each target ranging from Jan to Dec (see image below).
The user wanted to make an average of each target ranging from month in F3 to month in F4, which could be changed via the drop down list.
So cells G14:G16 would contain the average from let's say Jan to Dec for each of the 3 targets.
Eg average from Jan to Dec for target 1 would be 4,25, but drop down selection would be Apr to Nov, the average would be 4,88 and so on.
Me and another user arrived to the same result a bit differently:
credits to dosydos:
=AVERAGE(INDIRECT(CHAR(MATCH($F$3;$G$7:$R$7;0)+6+64)&ROW(F8)&":"&CHAR(MATCH($F$4;$G$7:$R$7;0)+6+64)&ROW(F8)))
credits to Mrrrr:
=AVERAGE(INDIRECT(MID(CELL("address";INDEX($G$7:$R$7;1;MATCH($F$3;$G$7:$R$7;0)));2;1)&ROW(F8)&":"&MID(CELL("address";INDEX($G$7:$R$7;1;MATCH($F$4;$G$7:$R$7;0)));2;1)&ROW(F8)))
If you round the results in the image for our answers, you will get the Expected data results 4, 5 and 7.
_______________________________________
|
|
| pus acum 4 ani |
|
