如何在excel中计算单元格?需要数多少说赢，多少说输 [英] How can i count cells in excel? Need to count how many say win, and how many say loss

问题描述

我如何在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中计算单元格?需要数多少说赢，多少说输的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！