SUMIFS question

CJ Christie

Hi, I'm trying to return a sum based on 2 criteria's.

The state of origin and the type. Not sure how to make it pull the $ or return 0 if its blank.

 =SUMIFS({1-Filing Status -State}, =State@row, {1-Filing Status-Type}, ="Form", {1-Filing Status -Fees}, 1, 0)) 

Thank you!!

Scott Orsey

HI @CJ Christie , You're close, but you'll want to review the syntax for SUMIFS(). It's a bit different than the SUMIF() function. Try this:

=SUMIFS({1-Filing Status -Fees}, {1-Filing Status -State}, State@row, {1-Filing Status-Type}, "Form")

Hope this helps. Be well

Scott Orsey

HI @CJ Christie , You're close, but you'll want to review the syntax for SUMIFS(). It's a bit different than the SUMIF() function. Try this:

=SUMIFS({1-Filing Status -Fees}, {1-Filing Status -State}, State@row, {1-Filing Status-Type}, "Form")

Hope this helps. Be well

DKazatsky2

Hi @CJ Christie,

Give this a try.

=SUMIFS({1-Filing Status -Fees}, {1-Filing Status -State}, State@row, {1-Filing Status-Type}, "Form")

Hope this helps,

Dave

CJ Christie

Success! Thanks for the help!