The simplest extension column, an example of the "maximum, minimum, average" value of an extension row
Design drawings
650) this.width=650; "src=" http://img.blog.csdn.net/20161228140211017 "style=" border:none; "/>
650) this.width=650; "src=" http://img.blog.csdn.net/20161228140251049 "style=" border:none; "/>
Related functions
=max (B2:E2)
=min (B2:E2)
=average (B2:E2)
This is a fixed column (satisfying the condition), a summation example of the extended row
Design drawings
650) this.width=650; "src=" http://img.blog.csdn.net/20161228140300094 "style=" border:none; "/>
650) this.width=650; "src=" http://img.blog.csdn.net/20161228140305986 "style=" border:none; "/>
Related functions
=sum (B2{b2 > 1} + c2{c2 > 1} + d2{d2 > 1} + e2{e2 > 1})
=sum (B2{b2 < 1} + C2{C2 < 1} + D2{d2 < 1} + E2{e2 < 1})
=sum (B2[!0]{b2 > 1})
=sum (B2[!0]{b2 < 1})
Fixed column expansion row table to find the number of (Row/column) method to satisfy the condition!
Design drawings
650) this.width=650; "src=" http://img.blog.csdn.net/20161228140314424 "style=" border:none; "/>
650) this.width=650; "src=" http://img.blog.csdn.net/20161228140320266 "style=" border:none; "/>
Related functions
=if (B2 > 1, 1, 0) + if (C2 > 1, 1, 0) + if (D2 > 1, 1, 0) + if (E2 > 1, 1, 0)
=count (Greparray (B2:e2, item < 1))
=count (B2{b2 > 1})
=count (B2{b2 < 1})
Extended row extension columns for maximum, minimum, average!
Design drawings
650) this.width=650; "src=" http://img.blog.csdn.net/20161228140328360 "style=" border:none; "/>
650) this.width=650; "src=" http://img.blog.csdn.net/20161228140334860 "style=" border:none; "/>
Related functions
=max (B2)
=min (B2)
=average (B2)
This article is from "The Bully World Blog" blog, please be sure to keep this source http://10549520.blog.51cto.com/10539520/1886882
FineReport: The application of functions under various conditions for the extension of the ranks