Challenges with combining SUMIFS and COUNTIFS

dani.pallum

I am using the Sheet Summary to input formulas helping me to track the COUNT of installs that took place in a given month/year. But now I want to SUM how many assets were installed at that location using the same date criteria. My formulas below are allowing me to COUNT how many rows (AKA customer locations) fit my criteria, but now I'm having an issue getting my formula to SUM how many assets (indicated in [Completed Count] column) were installed using the same date criteria.

The first formula that did work for me (COUNT of installs in 02 2025) is…

=COUNTIFS([Install Date]:[Install Date], IFERROR(MONTH(@cell), 0) = 2, [Install Date]:[Install Date], IFERROR(YEAR(@cell), 0) = 2025)

The next formula that is NOT working for me (SUM of assets installed in 02 2025) is…

=SUMIFS([Completed Count]:[Completed Count], [Install Date]:[Install Date], IFERROR(MONTH(@cell), 0) = 2, [Install Date]:[Install Date], IFERROR(YEAR(@cell), 0) = 2025)

Please help!

dani.pallum

Hello, I was able to get both formulas to work after testing out the =SUM([Completed Count]:[Completed Count]). Thank you for your input.

Paul Newcome

Are you getting an unexpected sum or an error output?

dani.pallum

Hi Paul,

I am getting #INVALID ARGUMENT SET error.

Paul Newcome

What happens if you just do:

=SUM([Completed Count]:[Completed Count])

dani.pallum

If I did that I would not capture the date criteria I am looking for. I need to be able to get the count by month.

Genevieve P.

Hi @dani.pallum

I believe Paul is suggesting this as a "troubleshooting step". If you get the same error when purely looking at the Completed Count column (without all the other criteria), then that lets us know that the data stored in that column may be seen as the wrong type… such as text instead of numerical values.

What you do get when you test that formula? Could you show us screen captures (but block out sensitive data)?

dani.pallum

Hello, I was able to get both formulas to work after testing out the =SUM([Completed Count]:[Completed Count]). Thank you for your input.