Complicated formula

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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