Share via

SUMIFS function returns zero or error

Anonymous
2023-12-05T21:03:45+00:00

Hi, I'm trying to make a SUMIFS function that will sum up multiple cells based on two separate sets of criteria. The criteria and the function are on two different sheets, same workbook.

I've tried two different functions. The first one returns 0 (zero) :

=SUMIFS('Total FY23-24'!D2:D82,'Total FY23-24'!A2:A82,'Total FY23-24'!C2:C82)

The second function returns an error:

=SUMIFS('Total FY23-24'!D2:D82,'Total FY23-24'!A2:A82,="August",'Total FY23-24'!C2:C82,="D")

I think the first one is returning 0 because I haven't specified any criteria in " ". Do I need brackets or something to make the second function work?

Here's the link to the spreadsheet without any personal details. I left both functions in separate cells for clarity. https://docs.google.com/spreadsheets/d/1LOWGLjUDzsWcyQ6n_RLZC04fzPY4MLe1/edit?usp=sharing&ouid=102822869772959657062&rtpof=true&sd=true

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2023-12-05T21:09:55+00:00

    Don't use = before the criteria.

    =SUMIFS('Total FY23-24'!D2:D82,'Total FY23-24'!A2:A82,"August",'Total FY23-24'!C2:C82,"D")

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. HansV 462.6K Reputation points
    2023-12-05T21:11:48+00:00

    If you change the formula to

    =SUMIFS('Total FY23-24'!$D$2:$D$82,'Total FY23-24'!$A$2:$A$82,A2,'Total FY23-24'!$C$2:$C$82,B2)

    you can fill or copy it down to the rows below.

    Was this answer helpful?

    0 comments