I've exhausted all efforts and im writing for help. I have 2 different sheets i'm working with. Sales and data. I need to take the total from from data and subtract it from sales (D10).
i need to add rows 4-8 in red column M and N. divide that by column H and I in green rows 4-8. Any help would be great!!!
<TBODY>
</TBODY>
i need to add rows 4-8 in red column M and N. divide that by column H and I in green rows 4-8. Any help would be great!!!
Calendar_Month</SPAN> | Split_Channel</SPAN> | Split</SPAN> | Total_Calls</SPAN> | On_Off_Calls</SPAN> | On_Calls</SPAN> | Off_Calls</SPAN> | NA_Calls</SPAN> | Total_Revenue</SPAN> | On_Off_Revenue</SPAN> | On_Revenue</SPAN> | Off_Revenue </SPAN> | NA_Revenue</SPAN> |
MAY</SPAN> | Retention</SPAN> | Campaign Roll Off_1</SPAN> | 60672</SPAN> | 60666</SPAN> | 45319</SPAN> | 15347</SPAN> | 6</SPAN> | ($67,846.99)</SPAN> | ($67,790.99)</SPAN> | ($50,552.71)</SPAN> | ($17,238.28)</SPAN> | ($56.00)</SPAN> |
MAY</SPAN> | Retention</SPAN> | RETENTION-CSG</SPAN> | 309587</SPAN> | 309350</SPAN> | 232150</SPAN> | 77200</SPAN> | 237</SPAN> | $1,042,143.36 </SPAN> | $1,041,196.58 </SPAN> | $796,552.40 </SPAN> | $244,644.18 </SPAN> | $946.78 </SPAN> |
MAY</SPAN> | Sales</SPAN> | SALES CSG</SPAN> | 237361</SPAN> | 237200</SPAN> | 178010</SPAN> | 59190</SPAN> | 161</SPAN> | $3,121,698.70 </SPAN> | $3,119,579.92 </SPAN> | $2,356,671.86 </SPAN> | $762,908.06 </SPAN> | $2,118.78 </SPAN> |
MAY</SPAN> | Sales</SPAN> | SALES-IN STATE ONLY</SPAN> | 5070</SPAN> | 5069</SPAN> | 3786</SPAN> | 1283</SPAN> | 1</SPAN> | $65,507.90 </SPAN> | $65,507.90 </SPAN> | $48,471.53 </SPAN> | $17,036.37 </SPAN> | $0.00 </SPAN> |
MAY</SPAN> | Sales</SPAN> | SALES_CABLE_MOVERS</SPAN> | 2236</SPAN> | 2234</SPAN> | 1681</SPAN> | 553</SPAN> | 2</SPAN> | $29,025.51 </SPAN> | $29,025.51 </SPAN> | $22,694.46 </SPAN> | $6,331.05 </SPAN> | $0.00 </SPAN> |
MAY</SPAN> | Sales</SPAN> | STL Sales</SPAN> | 10066</SPAN> | 2488</SPAN> | 1876</SPAN> | 612</SPAN> | 7578</SPAN> | $142,993.55 </SPAN> | $45,442.98 </SPAN> | $34,599.40 </SPAN> | $10,843.58 </SPAN> | $97,550.57 </SPAN> |
MAY</SPAN> | Sales</SPAN> | Walkers Sales Only</SPAN> | 8152</SPAN> | 8108</SPAN> | 6042</SPAN> | 2066</SPAN> | 44</SPAN> | $93,551.57 </SPAN> | $93,105.45 </SPAN> | $70,323.51 </SPAN> | $22,781.94 </SPAN> | $446.12 </SPAN> |
<TBODY>
</TBODY>