New Built in Functions 2007
 

I just ran into the Sumifs and Countifs functions and all I can say is good
deal.
I need not struggle with the Sumproduct function any longer.
Question: What other new functions are now available? Where can I find a
reference or listing.

Pepper

New Built in Functions 2007
 

See
http://www.rondebruin.nl/id.htm

IFERROR Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
SUMIFS Adds the cells in a range that meet multiple criteria
AVERAGEIF Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
AVERAGEIFS Returns the average (arithmetic mean) of all cells that meet multiple criteria.
COUNTIFS Counts the number of cells within a range that meet multiple criteria


Cube functions

CUBEKPIMEMBER Returns a key performance indicator (KPI) property and displays the KPI name in the cell.
CUBEMEMBER Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube.
CUBEMEMBERPROPERTY Returns the value of a member property from the cube.
CUBERANKEDMEMBER Returns the nth, or ranked, member in a set.
CUBESET Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set,
and then returns that set to Microsoft Office Excel.
CUBESETCOUNT Returns the number of items in a set.
CUBEVALUE Returns an aggregated value from the cube.

Or see Excel help


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Pepper" wrote in message ...
I just ran into the Sumifs and Countifs functions and all I can say is good
deal.
I need not struggle with the Sumproduct function any longer.
Question: What other new functions are now available? Where can I find a
reference or listing.

Pepper

New Built in Functions 2007
 

You still would need to struggle, they don't cover at all what sumproduct
can do.
There is also averageif and iferror, the latter the single most useful
function in 2007


--


Regards,


Peo Sjoblom




"Pepper" wrote in message
...
I just ran into the Sumifs and Countifs functions and all I can say is
good
deal.
I need not struggle with the Sumproduct function any longer.
Question: What other new functions are now available? Where can I find a
reference or listing.

Pepper

New Built in Functions 2007
 

Thank you both for the feedback, and I know it doesnt replace sumproduct,
just seems to pick up one aspect.

"Pepper" wrote:

I just ran into the Sumifs and Countifs functions and all I can say is good
deal.
I need not struggle with the Sumproduct function any longer.
Question: What other new functions are now available? Where can I find a
reference or listing.

Pepper

Plotting error bars in excel 2007
 

Dear folks,

I am struggling with Office excel 2007 for plotting standard error in excel.
In excel 2003 this fascility was there but in 2007 think it is not there.

MORE ELABORATE EXPLANATION OF THE PROBLEM:-

In 2003 excel. a separte Y error indicatior oprtion was there by using
wi=hich u can select the errors calculated by u and can display them in ur
graphs, but in excel 2007 I am not anyway able to show my own (calculated by
me) standard error. And if I use the standard error service in ecxel 2007, it
shows up the same standard error for all of them.

Please help me for it. Any questios on this regard are most welcome.
Thanks in advance . Please help me
Shalinee

"Pepper" wrote:

I just ran into the Sumifs and Countifs functions and all I can say is good
deal.
I need not struggle with the Sumproduct function any longer.
Question: What other new functions are now available? Where can I find a
reference or listing.

Pepper

Plotting error bars in excel 2007
 

Hi,

You can using Custom Specify Values.
For more detail read Jon's blog on the subject
http://peltiertech.com/WordPress/err...in-excel-2007/

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Shalinee" wrote in message
...
Dear folks,

I am struggling with Office excel 2007 for plotting standard error in
excel.
In excel 2003 this fascility was there but in 2007 think it is not there.

MORE ELABORATE EXPLANATION OF THE PROBLEM:-

In 2003 excel. a separte Y error indicatior oprtion was there by using
wi=hich u can select the errors calculated by u and can display them in ur
graphs, but in excel 2007 I am not anyway able to show my own (calculated
by
me) standard error. And if I use the standard error service in ecxel 2007,
it
shows up the same standard error for all of them.

Please help me for it. Any questios on this regard are most welcome.
Thanks in advance . Please help me
Shalinee

"Pepper" wrote:

I just ran into the Sumifs and Countifs functions and all I can say is
good
deal.
I need not struggle with the Sumproduct function any longer.
Question: What other new functions are now available? Where can I find
a
reference or listing.

Pepper

Plotting error bars in excel 2007
 

In the Format Error Bars dialog, click on Custom then on Specify Values.
A small dialog box opens where on can type numbers. But you can delete the
values in the two boxes and drag the mouse over a range on the worksheet to
get something like =Sheet1!$D$2:$D$10
See http://peltiertech.com/WordPress/err...in-excel-2007/

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Shalinee" wrote in message
...
Dear folks,

I am struggling with Office excel 2007 for plotting standard error in
excel.
In excel 2003 this fascility was there but in 2007 think it is not there.

MORE ELABORATE EXPLANATION OF THE PROBLEM:-

In 2003 excel. a separte Y error indicatior oprtion was there by using
wi=hich u can select the errors calculated by u and can display them in ur
graphs, but in excel 2007 I am not anyway able to show my own (calculated
by
me) standard error. And if I use the standard error service in ecxel 2007,
it
shows up the same standard error for all of them.

Please help me for it. Any questios on this regard are most welcome.
Thanks in advance . Please help me
Shalinee

"Pepper" wrote:

I just ran into the Sumifs and Countifs functions and all I can say is
good
deal.
I need not struggle with the Sumproduct function any longer.
Question: What other new functions are now available? Where can I find
a
reference or listing.

Pepper