SUM or COUNT and adding a row

Hi,

If I have COUNT(A1:A100) with a total in the row #101 and when a user insert
a row between the 98 and 99 rows the function will be COUNT(A1:A101) and the
total will be in the row #102, which is fine - the row has been added into
the function.

But, when a user adding a row between the total row (101) and the previous
row (100), the total will be in the row 102 but the function will remain the
same and the one row will be missing from the calculation.

How could I resolve it and give the user the flexibility to add a row the
total row?

Thanks
.

Relevant Pages

  • Re: SUM or COUNT and adding a row
    ... Alex wrote: ... But, when a user adding a row between the total row and the previous row, the total will be in the row 102 but the function will remain the same and the one row will be missing from the calculation. ... How could I resolve it and give the user the flexibility to add a row the total row? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Problem in the calculation method of iteration and time
    ... A grid is already active and calculation resolved. ... bar status message "Iteration" should ... could resolve ...
    (microsoft.public.mac.office.excel)
  • RE: how do I test for Integer?
    ... > I wish to test if the results of a calculation is an integer. ... An unknown ... > function perhaps in the stats package? ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Uploading/Adding documents to library issue
    ... resolve it? ... Any help/tips in the right direction would be greatly recieved as this ... Aidan ... Prev by Date: ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Table design
    ... "How do I resolve this issue" what issue? ... What is the calculation you need/want? ... Microsoft Access MVP ... "Duane Hookom" wrote: ...
    (microsoft.public.access.tablesdbdesign)