Thanks a million!!! I have been working on that all morning you ROCK!!!

"Elkar" wrote:

Will this work:

=IF(BH1114999,SUMIF($BB$2:$BB$54,"WoodsD",$BC$2:$ BC$54),"")

HTH,
Elkar


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