带有日期条件的 Google Sheets Sumifs [英] Google Sheets Sumifs with date condition

问题描述

我在尝试使用 SUMIFS 公式获取我在另一个 Google 表格上花费了一个月的钱时遇到错误.我是编写公式的新手，这是我找不到的第一个瓶颈.

I'm getting an error when trying to grab the money I have spent for a month on another Google Sheet using SUMIFS formula. I'm new to writing formulas and this is the first bottleneck I haven't been able to find.

我正在尝试在我的 Google 表格中编写一个公式，但出现错误.我是新手，所以请原谅我.

I'm trying to write a formula in my google sheet but getting an error. I'm new at this so forgive me.

在 Google 表格中，我有三张表格(摘要，这是主要的)、潜在客户和支出.

In the Google Sheet, I have three Sheets (Summary, which is main), Leads and Spend.

我正在尝试编写一个公式来获取我在特定月份花费的金额.在支出表中，我有日期、姓名和金额的列.

I'm trying to write a formula to grab how much I spent for a particular month. In the Spend sheet, I have column for the date, name and dollar amount.

这是我在没有运气的情况下尝试过的公式.

Here is the formula I have tried without luck.

Spend!G:G = Column with text for type of spend (Google PPC)
Spend!E:E = Column with cost of each spend
Spend!A:A = Column with the date

<小时>

=SUMIFS(Spend!G:G,"Google PPC",Spend!E:E,Spend!A:A,">=1/1/2019", Spend!A:A,"<=1/31/2019")

它应该只是给我在给定日期花费的总金额.但是我收到一条错误消息，提示SUMIFS 的数组参数大小不同"

It should just give me a total amount spent on the dates given. But I get an error that says "array arguments to SUMIFS are of different size"

推荐答案

有点不同的方法是:

=SUMPRODUCT(QUERY(Spend!A:G, "select E where year(A)=2019 and month(A)+1=1"))

这篇关于带有日期条件的 Google Sheets Sumifs的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！