问题

我尝试使用=SUMIFS(D4:D13,B4:B13,B4,C4:C13,C4)来回答问题，但似乎不起作用，希望能得到帮助。

英文:

Hello I am new to access and was trying to do a practice question from this site
https://excel-practice-online.com/functions/sumifs/

I tried =SUMIFS(D4:D13,B4:B13,B4,C4:C13,C4) for the answer but it doesn't seem to work help would be appreciated.

答案1

得分: 1

I tested your expression and it works for me. However, could use text instead of cell references for criteria.

=SUMIFS(D4:D13,B4:B13,"Gold",C4:C13,"NY")

To reference cells for criteria input, use cells dedicated for that purpose, such as F1 and F2, and enter the values you want:
Gold
NY

=SUMIFS(D4:D13,B4:B13,F1,C4:C13,F2)

英文:

I tested your expression and it works for me. However, could use text instead of cell references for criteria.

=SUMIFS(D4:D13,B4:B13,"Gold",C4:C13,"NY")

To reference cells for criteria input, use cells dedicated for that purpose, such as F1 and F2, and enter the values you want:
Gold
NY

=SUMIFS(D4:D13,B4:B13,F1,C4:C13,F2)

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。