excel 中,123,345,123,234,345求和,要现在单元格中显示123*2+345*2+234=1170,这一行数字中到底有几个123,有几个234等都用公式数出来,而不是人工数出来,怎么设置?用什么公式?
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/20 19:12:49
![excel 中,123,345,123,234,345求和,要现在单元格中显示123*2+345*2+234=1170,这一行数字中到底有几个123,有几个234等都用公式数出来,而不是人工数出来,怎么设置?用什么公式?](/uploads/image/z/635079-39-9.jpg?t=excel+%E4%B8%AD%2C123%2C345%2C123%2C234%2C345%E6%B1%82%E5%92%8C%2C%E8%A6%81%E7%8E%B0%E5%9C%A8%E5%8D%95%E5%85%83%E6%A0%BC%E4%B8%AD%E6%98%BE%E7%A4%BA123%2A2%2B345%2A2%2B234%3D1170%2C%E8%BF%99%E4%B8%80%E8%A1%8C%E6%95%B0%E5%AD%97%E4%B8%AD%E5%88%B0%E5%BA%95%E6%9C%89%E5%87%A0%E4%B8%AA123%2C%E6%9C%89%E5%87%A0%E4%B8%AA234%E7%AD%89%E9%83%BD%E7%94%A8%E5%85%AC%E5%BC%8F%E6%95%B0%E5%87%BA%E6%9D%A5%2C%E8%80%8C%E4%B8%8D%E6%98%AF%E4%BA%BA%E5%B7%A5%E6%95%B0%E5%87%BA%E6%9D%A5%2C%E6%80%8E%E4%B9%88%E8%AE%BE%E7%BD%AE%3F%E7%94%A8%E4%BB%80%E4%B9%88%E5%85%AC%E5%BC%8F%3F)
excel 中,123,345,123,234,345求和,要现在单元格中显示123*2+345*2+234=1170,这一行数字中到底有几个123,有几个234等都用公式数出来,而不是人工数出来,怎么设置?用什么公式?
excel 中,123,345,123,234,345求和,要现在单元格中显示123*2+345*2+234=1170,
这一行数字中到底有几个123,有几个234等都用公式数出来,而不是人工数出来,怎么设置?用什么公式?
excel 中,123,345,123,234,345求和,要现在单元格中显示123*2+345*2+234=1170,这一行数字中到底有几个123,有几个234等都用公式数出来,而不是人工数出来,怎么设置?用什么公式?
你要的这个公式将会是很长的一个公式,真有必要这样显示数据吗?
假设这几个数字写在A1至A5单元格
则另外一单元格可以写入公式
=IF(A1="","",IF(COUNTIF(A1:A5,A1)=1,A1,A1&"*"&COUNTIF(A1:A5,A1)))&IF(A2="","",IF(COUNTIF(A1:A2,A2)=2,"","+"&IF(COUNTIF(A1:A5,A2)=1,A2,A2&"*"&COUNTIF(A1:A5,A2))))&IF(A3="","",IF(COUNTIF(A1:A3,A3)>1,"","+"&IF(COUNTIF(A1:A5,A3)=1,A3,A3&"*"&COUNTIF(A1:A5,A3))))&IF(A4="","",IF(COUNTIF(A1:A4,A4)>1,"","+"&IF(COUNTIF(A1:A5,A4)=1,A4,A4&"*"&COUNTIF(A1:A5,A4))))&IF(A5="","",IF(COUNTIF(A1:A5,A5)>1,"","+"&IF(COUNTIF(A1:A5,A5)=1,A5,A5&"*"&COUNTIF(A1:A5,A5))))&"="&SUM(A1:A5)