The array formula does not work the way you want it to - it does not multiply everything on the row by D28.
Even if it did, there is no output to tell you that the data is unchanged.
If you want a warning that the data in E28 to Z28 is the same as expected try this:
In D28 enter the expected sum of the values in E28 to Z28
In C28 enter this Formula:
This is an ordinary formula, not an array formula.
It sums the values in cells E28 to Z28 on the worksheet named "DB2011" and compares the result to the value in cell D28. If it matches you see "OK" but if it doesn't match you see "Data changed"
However simple tests like this can be misleading because two or more changes could result in the same total.
To be sure that data has not changed you would need to use a check digit calculation, or some calculation that involves the position of the data as well as its absolute value.
You could use the following array formula:
This multiplies the value in each cell E28 to Z28 by the column number of each cell, then it Sums the results and finally compares the total to the stored value in D28, returning OK or the Data changed message.
Transposing two values for example, will result in a different total from this array formula, so warning of a data change.
You may wish to try this little exercise to help understand how $ signs affect formulas.
Note that the $ signs in formulas do not change the result of a formula =D28 returns the same value as =$D$28
Enter X in cell A1, Y in cell B1 and Z in cell A2
Now go to any empty cell, say D5 and enter =A1
Drag the formula one column to the right, then go back to D5 and drag it down one row
The three cells return the values X, Y and Z and the formulas are =A1, =B1 and =A2
Now change D1 to =$A$1 and repeat the two drags.
and look at the results and formulas - all three cells display X and all three formulas are =$A$1
then do it again using =$A1
and finally =A$1
Here are the four results with the formula used shown in column C:
C D E
A1 X Y
$A$1 X X
$A1 X X
A$1 X Y