google-sheets - 特定产品日期范围内的总和(sum total value from a date range for a specific product)

Question

I am looking to sum up multiple values from multiple cells where they will match a date and a product.

(我想总结多个单元格中的多个值，它们将与一个日期和一个产品匹配。)

like below: I have a date set in every cell in row 2 as below, and I have my categories in column A

(如下所示：我在第2行的每个单元格中都设置了一个日期，如下所示，并且在A列中有我的类别)

display 1

(显示1)

now I want to pick the total value (that is unit costs) from (below picture) this sheet where the date is equal to 1-dec (date) and the category is equal to office.

(现在，我想从（下图）此工作表中选择总值（即单位成本），该工作表的日期等于1-dec（日期），类别等于office。)

display 2

(显示2)

I tried using this formula =SUM(IFERROR(QUERY(DataSheet!A3:J10, "select I where A = "&C2&" and C = '"&A4&"'" , 0))) - but it is showing me 0, if I take out "iferror" option it shown "#N/A".

(我尝试使用此公式= SUM（IFERROR（QUERY（DataSheet！A3：J10，“选择I，其中A =”＆C2＆“和C ='”＆A4＆“'”，0）））-但如果我显示0我取出显示为“＃N / A”的“ iferror”选项。)

please help me to solve this issue.

(请帮助我解决此问题。)

  ask by adnan translate from so

Answer 1

等待大神答复