在Excel 2003中替换SUMIFS

本文介绍了在Excel 2003中替换SUMIFS的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

因此，我需要找到一个Excel 2003替代= SUMIFS(显然只有2007+).

So, I need to find an Excel 2003 substitute for =SUMIFS, which is only 2007+ (apparently).

该公式用于从收入列表中生成此汇总数据表，其中每个收入行都具有字段类型(静态，电子邮件或外联)和字段资金(ABC，QRS和XYZ).

The formula is used to generate this summary data table, from a list of revenue, where each revenue line has the field type (static, email or outreach) and the field fund (ABC, QRS and XYZ).

type fund total count average static ABC $12,390.88 171 $72.46 email ABC $6,051.32 65 $93.10 outreach ABC $8,835.00 138 $64.02 static QRS $12,925.44 79 $163.61 email QRS $9,305.44 99 $93.99 outreach QRS $1,799.00 49 $36.71 static XYZ $4,912.20 36 $136.45 email XYZ $75.00 2 $37.50 outreach XYZ $0.00 0 #DIV/0!

这是公式

`=SUMIFS('revenue'!G:G,'revenue'!AH:AH,Sheet2!A2,'revenue'!AI:AI,Sheet2!B2)`

其中G是美元金额，而AH和AI与类型或基金列匹配.

Where G is a dollar amount, and AH and AI are matching the type or fund column.

我如何在Excel 2003中使用它?

How do i get this to work in Excel 2003?

推荐答案

我最终克服的方法是创建一个合并了我需要检查的两列(ABCstatic，ABCemail等)的列.这种方式允许我仅使用一个'SUMIF'(使用两个链接在一起的SUMIF子句会导致条件的OR-ing，而不是AND-ing).

The way I ended up getting past this was to create a column that combined the two columns I needed to check (ABCstatic, ABCemail, etc.) Doing it this way allowed me to use just one 'SUMIF' (using two SUMIF clauses linked together results in OR-ing of the conditions, rather than AND-ing).

=SUMIF(Revenue!AJ2:AJ6400,Sheet2!A2, Revenue!G2:G6400)