subtotal
Thank you, Mike.
"Mike H." wrote:
I'd create an extra column and put a calculation similar to this in it:
=if(sumif(BreakColumn,Brakeitem=ThisColBrakeItem,O rigCol)1000,OrigCol/2,OrigCol). Then do you subtotals on this new column. HTH.
"Ira" wrote:
I ran subtotals. Now I have to write a code that if total for the group is
more than 1000, then every line item in the group must be devided by 2. Is
there a way to do it in excel?
|