流水号的公式应该如何修改

安然天涯

需求：流水号的公式是错误的，请问大神们，表格里的公式如何修改呢，谢谢！大神们指导，谢谢！

祝洪忠-

=TEXT(SUM(D$1:D1)+1,"1110012000")&"-"&TEXT(SUM(D$2:D2),"1110000000")+12000

试试

安然天涯

祝洪忠- 发表于 2024-5-15 15:54
=TEXT(SUM(D$1:D1)+1,"1110012000")&"-"&TEXT(SUM(D$2:D2),"1110000000")+12000

试试

为何往下拉是错误的

rym9401

1. =SUM(D$1:D1,1,1110012000)&"-"&SUM(D$2:D2,1110012000)

复制代码

monkey3500

="11100" & TEXT(12000+SUM(D$1:D1)+1,"@")
="11100" & TEXT(12000+SUM(D$1:D2),"@")
合并起来就是：="11100" & TEXT(12000+SUM(D$1:D1)+1,"@")& "-" &"11100" & TEXT(12000+SUM(D$1:D2),"@")
因为你的起始值不是1，是12001

quqiyuan

1. =TEXT(SUM(D$1:D1)+1+12000,"1110000000")&"-"&TEXT(SUM(D$2:D2)+12000,"1110000000")

复制代码

1786024734

rym9401 发表于 2024-5-15 16:14

简单粗暴有效

无关岁月

365自动溢出

1. =SCAN(1,D1:D32,SUM)+1110012000&"---"&SCAN(0,D2:D33,SUM)+1110012000

复制代码

小小小透明

=TEXT(1110012001+SUM($D$1:D1),0)&"-"&TEXT(1110012000+SUM($D$2:D2),0)