Скріншот прикріпив.
Формули:
B13: =AVERAGE(B4:F10)
B14: =MAX(B4:F10)
B15: =MIN(B4:F10)
B16: =COUNTIF(B4:F10,">0")
B17: =COUNTIF(B4:F10,"<0")
B18: =COUNTIF(B4:F10,"=0")
G13: =AVERAGE(G4:K10)
G14: =MAX(G4:K10)
G15: =MIN(G4:K10)
G16: =COUNTIF(G4:K10,">0")
G17: =COUNTIF(G4:K10,"<0")
G18: =COUNTIF(G4:K10,"=0")
L13: =AVERAGE(L4:P10)
L14: =MAX(L4:P10)
L15: =MIN(L4:P10)
L16: =COUNTIF(L4:P10,">0")
L17: =COUNTIF(L4:P10,"<0")
L18: =COUNTIF(L4:P10,"=0")
O13: =AVERAGE(B4:P10)
O14: =MAX(B4:P10)
O15: =MIN(B4:P10)
O16: =COUNTIF(B4:P10,">0")
O17: =COUNTIF(B4:P10,"<0")
O18: =COUNTIF(B4:P10,"=0")
Copyright © 2024 SCHOLAR.TIPS - All rights reserved.
Answers & Comments
Скріншот прикріпив.
Формули:
B13: =AVERAGE(B4:F10)
B14: =MAX(B4:F10)
B15: =MIN(B4:F10)
B16: =COUNTIF(B4:F10,">0")
B17: =COUNTIF(B4:F10,"<0")
B18: =COUNTIF(B4:F10,"=0")
G13: =AVERAGE(G4:K10)
G14: =MAX(G4:K10)
G15: =MIN(G4:K10)
G16: =COUNTIF(G4:K10,">0")
G17: =COUNTIF(G4:K10,"<0")
G18: =COUNTIF(G4:K10,"=0")
L13: =AVERAGE(L4:P10)
L14: =MAX(L4:P10)
L15: =MIN(L4:P10)
L16: =COUNTIF(L4:P10,">0")
L17: =COUNTIF(L4:P10,"<0")
L18: =COUNTIF(L4:P10,"=0")
O13: =AVERAGE(B4:P10)
O14: =MAX(B4:P10)
O15: =MIN(B4:P10)
O16: =COUNTIF(B4:P10,">0")
O17: =COUNTIF(B4:P10,"<0")
O18: =COUNTIF(B4:P10,"=0")