Open Side Menu
Skip to content
Tech Community
Community Hubs
Products
Topics
Blogs
Events
Skills Hub
Community
Register
Sign In
Microsoft Community Hub
Communities
Products
Microsoft 365
Excel
Forum Discussion
shan_sh_an
Copper Contributor
Dec 07, 2022
关于SUM公式运用
我想要两列的和大小等于大于100的标识成红色,但是=sum(E2:F2)>=100为什么是错误的
View Full Discussion (2 Replies)
Show Parent Replies
peiyezhu
Bronze Contributor
Dec 07, 2022
=sum(E:E,F:F)>=100 try this
shan_sh_an
Copper Contributor
to peiyezhu
Dec 07, 2022
不行