Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Problem with Large Excel File | Excel Discussion (Misc queries) | |||
formula problem | New Users to Excel | |||
how to change a formula for a large group of cells | Excel Worksheet Functions | |||
Need one formula for large sections of one column, but.... | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |