=if(BH11>14999 ,SUMIF($BB$2:$BB$54,"WoodsD",$BC$2:$BC$54), 0)

or something similar to that...
--
HTH...

Jim Thomlinson


"SweetSin80" wrote:

> I have this formula =SUMIF($BB$2:$BB$54,"WoodsD",$BC$2:$BC$54) which works
> fine, problem is I only want to see that sum IF BH11>14999.
>
> Basically, this is a commission formula, calculating only when a Rep hits
> $15,000 in sales.
>
> I keep getting erros, too many arguements, incorrect. etc.
>
> Could really use some help with this one, BIG GOLD STAR TO WHOEVER CAN HELP
> ME :o))
>