Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complicated formula
a b c d .. .. j
7177-168-000 7177 100.00 7177-168-000 7177 1 100.00 I know this is complicated but I need to know if I can put a value in "g". I'm starting with, if c=1, add the total of "h" when "b" is the same number. In this case "g" would be 200.00 I get the value of "True" from my formula: =IF($C8=1,SUMIF($B$3:$B$2156,$B8,$J$3:$J$2156),"") I'm almost positive that this can be done, but I'm at a loss, maybe i've just stared at it too long. I would appreciate any suggestions. Thanks, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated Formula | Excel Worksheet Functions | |||
how do i set up a complicated IF formula | Excel Discussion (Misc queries) | |||
complicated formula | Excel Worksheet Functions | |||
Complicated IF Formula | Excel Worksheet Functions | |||
Complicated formula | Excel Worksheet Functions |