Hi,

I am trying to automatically update a summary worksheet. So basically
anytime one of the other worksheets are updated, this summary is changed.
Example, I have 7 tabs, each one representing software license purchases for
a year, and then the seventh tab is a summary. Not all license titles are
going to be the same on each tab, so I think I need to do an IF/SUM function
of some sort.

IF the text is the same, then add these cells from each worksheet.

I followed the instructions to set up a 3D function but ran into a problem.
Here's what I did.
Opened spreadsheet and clicked on summary tab.
Followed the instructions for a 3D function.
Typed = in the refers to box.
Clicked on the first tab and then held shift and clicked the last tab.
It then says to select the cell or range of cells to be referenced. I
selected all of the cells I wanted to reference on the summary tab. Is this
wrong?
Thanks,
Steve P.