SUMIF a field if box unchecked

Annie Dunn

I'm trying to sum a column, [Total Commission], if [Rep] is ES and the [Rep Paid] column does NOT have a check mark.

It's looking like this so far:

 

=SUMIFS([TOTAL COMMISSION]:[TOTAL COMMISSION], [SALES REP]:[SALES REP], "ES", [REP PAID]:[REP PAID], ??? (this is where I get lost.)

Help?

Andrée Starå

Hi Annie,

Try this.

=SUMIFS([TOTAL COMMISSION]:[TOTAL COMMISSION]; [SALES REP]:[SALES REP]; "ES"; [REP PAID]:[REP PAID]; 0)    

The same version but with the below changes for your and others convenience.  

=SUMIFS([TOTAL COMMISSION]:[TOTAL COMMISSION], [SALES REP]:[SALES REP], "ES", [REP PAID]:[REP PAID], 0)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting