=if(BH1114999 ,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 BH1114999.

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))