公式设定A1:A1000区域,具体区域请根据表格实际情况修改: =SUMPRODUCT(--(0&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1:A1000,"¥",),"元",),"无",)))
公式设定A1:A1000区域,具体区域请根据表格实际情况修改: =SUMPRODUCT(--(0&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1:A1000,"¥",),"元",),"无",)))
Copyright © 2018 - 2021 www.yd166.com., All Rights Reserved.