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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complicated formula
Your formula should work.
=IF($C8=1,SUMIF($B$3:$B$2156,$B8,$J$3:$J$2156),"") You get the sum of the values in j for each row where the value in B equals the Value in B8. You said you wanted to sum column h, but your formula is summing j. It should show a "" if c < 1. I don't see how this formula (as written) could return True) -- Regards, Tom Ogilvy "Mike" wrote in message ... 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 |
Reply |
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 |