3D Function Error

[Guest]

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.

 

[sseavert]

I am sorry, but yes this is wrong. The way SUMIF works is as follows:

=SUMIF(RANGE,REF,SUMCOL)

RANGE = the range of cells you are looking through
REF = the vairable you are looking for
SUMCOL = the column / range you are summarizing

So.... Given the folowing,

A B
1 1001 50
2 1002 40
3 1003 20
4 1004 30
5 1001 10
6 1003 20

AND the formula =SUMIF(A1:A6,1001,B1:B6)

your result would be "60"


Hope this helps

 

[Peo Sjoblom]

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

http://www.nwexcelsolutions.com/advanced_function_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