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 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.
Consolidation by positionMake 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.