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

07-31 03:30