Results 1 to 4 of 4
Hybrid View
-
9th May 2022 12:34 #1Lenovo R500
-
9th May 2022 13:23 #2Registered User
Join Date: Aug:2009
Location:
Posts: 265
DAM ( ), :
(copy/paste A1 , )Code:;1 ;4 Date;"=""From ""&B1&"" to ""&B2" "=UNIQUE(SORT(INDEX(DAM;;1)))";"=SUMPRODUCT((INDEX(DAM;;1)=$A4)*(INDEX(DAM;;2)>=B$1)*(INDEX(DAM;;2)>=B$2)*INDEX(DAM;;4)*INDEX(DAM;;5))/SUMPRODUCT((INDEX(DAM;;1)=$A4)*(INDEX(DAM;;2)>=B$1)*(INDEX(DAM;;2)>=B$2)*INDEX(DAM;;5))"
BGN.
-
11th May 2022 10:36 #3Registered User
Join Date: Jul:2011
Location: sofia
Posts: 42
, SORT.
( ) - YEAR, MONTH, ( 1-4 1, 5-8 2 .. 6).
1 : , - - , B - , C - , D AVERAGEIFS , . 12 6 - 72 .
2 :
-
12th May 2022 02:22 #4




Reply With Quote
7th May 2023, 16:02 in PC