Sumproduct-how do i do that and keep the right syntax?

someone receommended me this statement

=SUMPRODUCT(SP-B!$M$12:$M$10000,(SP-B!$E$12:$E$10000="")+(YEAR(SP-B!$E$12:$E$10000)=2006))

it works great but i'm trying to remove the part in bold. how do i do that and keep the right syntax?

thank you

Try

=SUMPRODUCT(SP-B!$M$12:$M$10000,--(YEAR(SP-B!$E$12:$E$10000)=2006))

Originally Posted by daddylonglegs

Try

=SUMPRODUCT(SP-B!$M$12:$M$10000,--(YEAR(SP-B!$E$12:$E$10000)=2006))

that worked thank you