Skip to content
Tech Community
Community Hubs
Products
Topics
Blogs
Events
Microsoft Learn
Lounge
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 08, 2022
不行
Resources