链接工作表时使用COUNTIFS公式 [英] Using COUNTIFS formulas when linking worksheets

问题描述

我想尽可能的详细。所以让我提供一下我的电子表格的样子

 列H列Q 
行11是Win 
第12行没有赢
第13行是损失
 ... 
 ... 
行61 YES Win 
  

我曾经给我一个优胜者的计算是 = COUNTIFS（H11：H61，YES，Q11：Q61， Win），损失的 = COUNTIFS（H11：H61，是，Q11：Q61，丢失） = COUNTIFS（输入H11：H61， YES，Q11：Q61， 赢）。任何建议，为什么这可能不工作，或者可能更好的解决这个问题？

解决方案

你需要包括表单名称在所有范围内，即

= COUNTIFS（Input！H11：H61，YES，Input！Q11：Q61，Win ）

I want to be as detailed as possible. So Let me provide you with the look of my spreadsheet

          Column H       Column Q
Row 11      YES            Win
Row 12       NO            Win
Row 13      YES            Loss
...
...
Row 61      YES            Win

The calculation that I used to give me a count of "Winners" is =COUNTIFS(H11:H61,"YES",Q11:Q61,"Win") and the one for "Losses" is =COUNTIFS(H11:H61,"YES",Q11:Q61,"Loss") - seems to be working well. However, this calculation is on sheet Input. I would like to have this calculation done on a totally different sheet entitled Results. However, my calculation doesn't seem to be working properly. Here is an example of the calculation I placed on my Results sheet. =COUNTIFS(Input!H11:H61,"YES",Q11:Q61,"Win"). Any suggestions as to why this might not be working, or maybe a better solution for this problem?

解决方案

You need to include the sheet name in all the ranges, i.e.

=COUNTIFS(Input!H11:H61,"YES",Input!Q11:Q61,"Win")

这篇关于链接工作表时使用COUNTIFS公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！