ExcelBanter - Problem with a large formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Problem with a large formula (https://www.excelbanter.com/excel-discussion-misc-queries/71351-problem-large-formula.html)

SweetSin80

Problem with a large formula

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

Elkar

Problem with a large formula

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

All times are GMT +1. The time now is 10:55 PM.