Excel操作

1. 根据条件求和

　　=sumif(range，criteria，sum_range)

　　range：要按条件查找的区域

　　criteria：条件，通配符*可以用来匹配任意字符，？匹配单个字符，和正则表达式相同

　　sum_range：求和区域

　　如：=SUMIF(D5:D13,"*发票*",N5:N13)

2.金额直接变大写

="合计人民币（大写）:"&IF(N16=0,"零元",IF(N16<0,TEXT(INT(ABS(N16)),"负[DBNum2]g/通用格式")&"元"&IF((INT(N16*10)-INT(N16)*10)=0,"",TEXT(INT(N16*10)-INT(N16)*10,"[DBNum2]")&"角")&IF((INT(N16*100)-INT(N16*10)*10)=0,"整",TEXT(INT(N16*10)-INT(N16*10),"[DBNum2]")&TEXT(INT(N16*100)-INT(N16*10)*10,"[DBNum2]")&"分"),TEXT(INT(N16),"[dbnum2]")&"元"&IF(INT(N16*10)-INT(N16)*10=0,"",TEXT(INT(N16*10)-INT(N16)*10,"[dbnum2]")&"角")&IF((INT(N16*100)-INT(N16*10)*10)=0,"整",TEXT(INT(N16*10)-INT(N16*10),"[DBNum2]")&TEXT(INT(N16*100)-INT(N16*10)*10,"[DBNum2]")&"分")))