Help with SUMIFS

Megan T

I am trying to calculate the sum of "Total Clear" IF the date from "Form Date Field" is today, and the "Cell" value is "Z".

Andrée Starå

Hi @Megan T

Try something like this.

=SUMIFS([Total Clear]:[Total Clear]; [Form Date Field]:[Form Date Field]; TODAY(); Cell:Cell; "Z")

The same version but with the below changes for convenience.

=SUMIFS([Total Clear]:[Total Clear], [Form Date Field]:[Form Date Field], TODAY(), Cell:Cell, "Z")

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Megan T

Hey @Andrée Starå, I’m still getting a #INVALID OPERATION error. :-/ would this have anything to do with the fact that the date is system generated?

Andrée Starå

@Megan T

No, it should work, so there has to be something else causing the error.

Can you paste the exact formula?

Megan T

=SUMIFS([Total Clear]:[Total Clear], [Form Date Field]:[Form Date Field], TODAY(), Cell:Cell, "Z")

Andrée Starå

@Megan T

Yes, that looks correct.

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Megan T

@Andrée Starå I created a dummy sheet to share with you, and the formula works fine there. The only difference I can think of is the number of rows. Is there a limit to the number of cells that can be referenced? Our actual sheet has roughly 6,000 rows.

Andrée Starå

@Megan T

Yes, there are limits, but I don't think was the reason for it not working.

Is it working now?