Using Threed Add-In

chacooke

New Member
Joined
Oct 16, 2006
Messages
7
Calling on all you great minds one more time...

I'm have a work sheet that is currently using the threed formula

=AVERAGE(THREED('4:5'!G131))

Now, I'm trying to add the =if(iserror to it and getting error's that my formula is not correct...

Here is the formula that I was trying to use

=if(iserror(average(threed('4:5'!g131)),"",(average(threed(.....

I have also tried without the leading ( for the second average...

let me know if anyone has some idea's.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,114,059
Messages
5,545,758
Members
410,704
Latest member
Cobber2008
Top