|
发表于 2013-11-15 19:21
|
显示全部楼层
本楼为最佳答案
无止学习 发表于 2013-11-15 18:53
这个很好,但我在C列改个为24V,后面计算是错误值,怎么规避错误值,因为我现实表格里参差着不带“#”的, ...
容错可以这样考虑
excel2007的话:- =iferror(SUM(((LEFT(C5:C11,2)="13")+(LEFT(C5:C11,2)="16")+(LEFT(C5:C11,2)="22"))*(ISERROR(FIND("反",C5:C11)))*(D5:D11)),"")
复制代码 excel2003:- =if(iserror(SUM(((LEFT(C5:C11,2)="13")+(LEFT(C5:C11,2)="16")+(LEFT(C5:C11,2)="22"))*(ISERROR(FIND("反",C5:C11)))*(D5:D11))),"",SUM(((LEFT(C5:C11,2)="13")+(LEFT(C5:C11,2)="16")+(LEFT(C5:C11,2)="22"))*(ISERROR(FIND("反",C5:C11)))*(D5:D11)))
复制代码 |
|