Check your source range references   Make sure you entered the references to all source ranges correctly.

Check the summary function   Make sure you selected the appropriate summary function (summary function: A type of calculation that combines source data in a PivotTable report or a consolidation table, or when you are inserting automatic subtotals in a list or database. Examples of summary functions include Sum, Count, and Average.) in the Consolidate dialog box.

Check the consolidation   To avoid problems with the shape of the destination area, select the upper-left cell of the area before you create the consolidation. Make sure you leave enough cells to the right and below this cell for the consolidated data. The Consolidate command fills in the area as needed.

Make sure each source area contains the same range of similar data in the same order.

Include row or column labels   In the Consolidate dialog box, under Use labels in, make sure you selected the Top row or Left column check box, or both. And make sure you included corresponding labels in the source ranges.

Check for identical category labels   Make sure you entered category labels with identical spelling and capitalization in all source areas. For example, labels Annual Avg. and Annual Average are different and will not consolidate.

Check for unique categories   Make sure any categories that you don't want to consolidate have unique labels that appear in only one source range.