joeyc
08-19-2008, 02:06 PM
1.) I have one problem. I need to be able to automatically calculate the values in column D.
2.) Note, the number of products are undefined. I may have 3 products or I have 10. Also, the number of rows per product are undefined. I may have 25 or I may have 1,000.
3.) Let me explain what I did in column D. For every row of every product in column D I performed a calcuation. I need one specific calculation if a number in column C is positive and another calculation if the number in column C is negative. The range apart of the sumif function corresponds to the range of the product within this file. I have three products. The other two are down below.
4.) Here is an example. I start with D2. Is C2 positive or negative? Negative. So use the code below.
-C2/SUMIF($C$2:$C$390,"<0",$C$2:$C$390))
5.) Here is another example from cell D12. Is D12 positive or negative. Positive. So use the code below:
C12/SUMIF($C$2:$C$390,">0",$C$2:$C$390)
6.) By the way, I picked up a macro from someone on this board where the names of my product will be listed starting in K17 and going across. Maybe this can help in some way?
Thank you in advanced for any help. It all sounds weird but this would be very helpful. I am almost done here.
2.) Note, the number of products are undefined. I may have 3 products or I have 10. Also, the number of rows per product are undefined. I may have 25 or I may have 1,000.
3.) Let me explain what I did in column D. For every row of every product in column D I performed a calcuation. I need one specific calculation if a number in column C is positive and another calculation if the number in column C is negative. The range apart of the sumif function corresponds to the range of the product within this file. I have three products. The other two are down below.
4.) Here is an example. I start with D2. Is C2 positive or negative? Negative. So use the code below.
-C2/SUMIF($C$2:$C$390,"<0",$C$2:$C$390))
5.) Here is another example from cell D12. Is D12 positive or negative. Positive. So use the code below:
C12/SUMIF($C$2:$C$390,">0",$C$2:$C$390)
6.) By the way, I picked up a macro from someone on this board where the names of my product will be listed starting in K17 and going across. Maybe this can help in some way?
Thank you in advanced for any help. It all sounds weird but this would be very helpful. I am almost done here.