-
Zxmzxm11
2020-07-04
0628期数据分析DAY01——Excel基础
本篇目录一、常用EXCEL函数二、数据透视表一、常用EXCEL函数COUNTIF(range,criteria) 【如=COUNTIF(B2:K2,“b”)】COUNTIFS(range1,criteria1,…) 【如=COUNTIFS(B2:B11,“b”,C2:C11,“b”)】SUMIF(range, criteria, [sum_range])
-
Zxmzxm11
2020-06-29
整理总结:EXCEL基础(持续更新)
@[TOC](本篇目录)### 一、常用EXCEL函数1. COUNTIF(range,criteria) 【如=COUNTIF(B2:K2,"b")】2. COUNTIFS(range1,criteria1,...) 【如=COUNTIFS(B2:B11,"b",C2:C11
-
Zxmzxm11
2020-06-29