参考一下公式:1、有数据的单元格个数:=COUNTA(统计区域)2、多个工作表的:=COUNTA(Sheet1!统计区域)+COUNTA(Sheet2!统计区域)+COUNTA(Sheet3!统计区域)3、多个工作簿的:=COUNTA([Book1.xls]Sheet1!统计区域)+COUNTA([Book2.xls]Sheet1!统计区域)+COUNTA([Book3.xls]Sheet1!统计区域)
参考一下公式:1、有数据的单元格个数:=COUNTA(统计区域)2、多个工作表的:=COUNTA(Sheet1!统计区域)+COUNTA(Sheet2!统计区域)+COUNTA(Sheet3!统计区域)3、多个工作簿的:=COUNTA([Book1.xls]Sheet1!统计区域)+COUNTA([Book2.xls]Sheet1!统计区域)+COUNTA([Book3.xls]Sheet1!统计区域)
Copyright © 2018 - 2021 www.yd166.com., All Rights Reserved.