sum problem

[seenfresh]

I have a list of data linked from another worksheet within the same workbook and I have a basic sum function to total all the data linked

The function is fine sum(p827), but I get a #REF! error

Now the data that has been extracted (linked) contains a subtotal function, could this be the problem

I'm not sure why the sum function is not working?

Any help would be great!

Thanks in advance,

 

[texasalynn]

does the data being summed have a #REF error in it?

 

[seenfresh]

NO

 

[seenfresh]

It's kind of weird... I don't want to copy paste the values because I need the links, but I've never encountered this problem before?

 

[seenfresh]

Well Scratch that problem, I have so many rows... I actually was about to past html of my ws on the board and realized that a hidden row had a ref error.... sorry about the confussion... I am actually thankful of the html maker who knew if could be an auditing tool...


Thanks you,

 

[texasalynn]

well good you worked it out