当前位置：网站首页>[excel] SUMIF merge cells

[excel] SUMIF merge cells

2022-07-21 12:02:00 【sayyy】

Preface

Insert picture description here

operation

1. Add hidden column

Insert picture description here

  • =LOOKUP(" sit ",$A$1:A3)： Split the merged cells
  • =VLOOKUP(" sit ",$A$2:A3,1)： You can also split the merged cells in this way

2. SUMIF merge cell

Insert picture description here

3. Hide columns

Insert picture description here

Reference resources

https://www.sohu.com/a/190980457_753914

原网站

版权声明
本文为[sayyy]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/202/202207201656155512.html

边栏推荐

猜你喜欢

随机推荐