If you are trying to do a SUMIF or a COUNTIF there is info here

http://www.nwexcelsolutions.com/adva...ction_page.htm

number 3, you can download a sample of the SUMIF, just adapt the same
formula to COUNTIF


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"srpettew" wrote in message
...
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.