各路Excel大神,急求 ,在线急用!!!!

2025-06-21 20:34:47
推荐回答(3个)
回答1:

="X元餐 " & COUNTIFS(B1:B6004,"*",E1:E6004,"45",J1:J6004,"一体机") &"单"

回答2:

----57132899----
=E1&F1
这样?没看到行号列标

回答3:

c2=a2&" "&b2&"单"