# Problem with updating cells

• From: "C. Mark Cowart" <cmarkcowart yahoo com>
• To: "gnumeric-list gnome org" <gnumeric-list gnome org>
• Subject: Problem with updating cells
• Date: Mon, 26 Sep 2011 17:44:31 -0700 (PDT)

Problem with updating cells that are referenced in other sheets

Gnumeric version 1.10.16
Windows 7 SP1 64-bit

I have two sheets in one Gnumeric workbook.  One sheet, "Numbers", contains a series of number

groups.  Each number group has six two-digit numbers.  Each two-digit number is in one cell.

There is one number group on one row.  There are several hundred number groups, therefore, there

are several hundred rows.

Each two-digit number in each number group of six numbers is in a column.  The first two-digit

number in a number group is in the first column.  The second two-digit number in a number group

is in the second column, etc.

The goal is to determine the frequency of instances of a particular number in a given column.

For example, how often does the number 01 occur in the first column of numbers?  This answer is

then referenced to second sheet, "Numbers_Frequencies".

An example of the formula that is used for this action is as follows:
"=COUNTIF('Numbers'!\$B:\$B, 01+'Numbers_Frequencies'!C6)".

The COUNTIF function for the above formula is to count the number of instances of the number 01

in column B on Sheet "Numbers" and reference it to cell C6 on Sheet "Numbers_Frequencies".

There are 326 variations of the above COUNTIF formula.  They calculate all of the instances of

all of the numbers in a given range of numbers for all of the number groups in one sheet, and

then reference them to a second sheet.

After entering all of the formulas, I was able to undate all of the instances of the given

numbers that were already in the Numbers Sheet to the appropriate reference cells in the

Numbers-Frequencies Sheet, but when I added a new row of numbers, the instances did not update

properly.  In fact, most, if not all, of the frequency values were changed, and incorrectly.  In

other words, I had a major screw up.

Fortunately, I had a back up of the original workbook.  I attempted to update with a new row of

numbers again, but the same thing occurred.  So, I have a problem.  Gnumeric does not seem to do

what it is supposed to do.

What could be the problem?  Is there a bug in Gnumeric 1.10.16 that prevents the accurate

updating of values between sheets?

Thanks for the help.

Mark