divisor

Hi friends, I'm not sure if this is possible or not. Need a formula to SUM a column that could have five entries or it could have 500 entries. I also need it to divide the total by the exact number of entries and it needs to be dynamic, ie. someone enters a new amount in the column and the...

Hello, Below is a list of data. I am trying to find a common Divisor for the last column ( Dim. weight w/o Divisor) that will make the rated weight equal to the shipment rated weight. We can throw out outliers like line 2 with 24 rated weight and 1 original weight. Any ideas? I am stuck! Rated...

I'm trying to use a formula to count the number of cells with a divisor of 6 in but I'm having trouble.. I've tried =SUMPRODUCT(--(MOD(F11:J11,6))=0) but it doesn't seem to work - any ideas??

Good afternoon all Dividing the below, when the result is greater than 8 add .5 to the divisor and then divide the dividend by the new divisor. <colgroup><col width="70" style="width:53pt"> <col width="86" style="width:65pt"> <col width="96" style="width:72pt"> </colgroup><tbody> 70.25...

If I have a workbook and the first worksheet is the main worksheet that sums other worksheets, how do i get the divisor number to change each time I add a new worksheet. For examble in january the main sheet would divide each row by 1, but when I add a new worksheet for february, it would...