excel最小的一个范围的子集 [英] excel min of a subset of a range

问题描述

我有一个Excel表格，有两列感兴趣的年份和捐款。年度值是2008,2009,2010等...

我想在2009年获得所有捐款的最低限度。我尝试过

MIN（IF（Year =2009，Donations，）

这个问题是2009年以前的几年下降到，因此最小为0。

是否有不同的功能我应该使用。

解决方案

你的公式是正确的，MIN会忽略文本。要检查的几件事：

确保数据在几年是真正的文本，如果是一个数字，你需要删除2009年左右的引号，或者找不到任何东西。

确保你输入公式Control + Shift + Enter，而不只是Enter，Excel将在公式栏中的公式中放置花括号，表示它是一个数组公式。

确保你不是实际上得到正确的答案，也就是说，确保2009年没有零条目不太可能你会记录一个零的捐款，但值得一看。

如果你的年份数据实际上是文字，也许是因为它是导入的，那么捐赠数据就可能也是文字。如果是这样，请使用

  MIN（IF（Year =2009，Donations * 1，））
  

如果可能，* 1将强制文字号码。

I have an excel sheet with two columns of interest Year and Donations. The year values are 2008,2009,2010 etc...

I would like to get the minimum of all donations for 2009. I have tried

MIN(IF(Year="2009",Donations,"")

The problem with this is for years other than 2009 it falls to "" and hence the min is 0.

Is there a different function I should be using.

解决方案

The formula you have is correct. MIN will ignore text. A couple of things to check:

Make sure the data in Years is really text. If it's a number, you need to remove the quotes around 2009 or it won't find anything.

Make sure you're entering the formula with Control+Shift+Enter, and not just Enter. Excel will put curly braces around the formula in the formula bar indicating it's an array formula.

Make sure you're not actually getting the correct answer. That is, make sure there are no entries of zero for 2009. Seems unlikely you would record a donation of zero, but it's worth a look.

If your Year data is actually text, maybe because it's imported, then it's possible the Donations data is text too. If that's the case use

MIN(IF(Year="2009",Donations*1,""))

The *1 will force the text to a number if possible.

这篇关于excel最小的一个范围的子集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！