Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with a large formula
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)) |
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) | |||
Baffling formula problem | Excel Discussion (Misc queries) |