For example, you might have sales data for each of your four main departments on four separate sheets. ... Excel's Sum function supports multiple sheet and cell references. Getty.