本文介绍了如何在excel中计算单元格?需要数多少说赢，多少说输的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我如何在excel中计算单元格?需要计算有多少说赢，有多少说输.例如，C 列包含单词 WIN 或 LOSS.我想要一个单元格来计算并显示记录(例如 23-11)我一直在尝试 IF 函数，但我无法让它通过并全部计算出来.我想我需要一个变量来跟踪输赢.谢谢！
How can i count cells in excel? Need to count how many say win, and how many say loss. For example column C contains either the word WIN or LOSS. i want to have a cell that counts that and displays a record (ex. 23-11) Ive been trying IF functions but i cant get it to go through and count them all. im thinking i need a variable to keep track of the wins and losses. thanks!
推荐答案
你需要这个公式
=CONCATENATE(COUNTIF(A1:A9,"WIN")," - ",COUNTIF(A1:A9,"LOSS"))
这篇关于如何在excel中计算单元格?需要数多少说赢，多少说输的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！