EASY for someone Excel SUMIFS question (see photo of text question -thanks!)

New Contributor
4 Replies
I believe this is what you're trying to do:

=SUMIFS(Table1[Debits], Table1[Category], "Gardening", Table1[Date], ">=" & DATE(2022, 4, 1), Table1[Date], "<=" & DATE(2022, 4, 7))
Hmmmm --- Getting the error "The formula is missing an opening or closing parenthesis" -- ?

@KJPNWester Since you did not post your formula, I can't tell you anything beyond the error message - that you are probably missing an opening or closing parenthesis. The formula I posted does not have that issue, perhaps double check (of course, the table name will have to be changed to whatever yours is called)?

 

JMB17_0-1650866830718.png

 

@JMB17 Ok thank you! I'll keep working on it!