How do I refer to non-contiguous cells in a compound function ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to do a ttest on non-contiguous cells, but am having trouble making
excel understand where the commas delimit lists of cells and where they
delimt the function's elements. So I'd like: ttest({a1,h1},{b2,i2},2,1)
which doesn't work ...

Thanks

Adrian
 
Adrian,

Try:

=TTEST((A1,H1),(B2,I2),2,1)

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select non-contiguous cells in Excel 2007 3
Formula to define non-contiguous range? 7
TTest with values in non-contiguous ranges 6
XIRR and Non Contiguous Cells 2
Looping through Non contiguous cells in a row 11
average of non contigous data to also exclude zeros 14
How do I change the active cell in a non contiguous range or selection? 0
referring to formula in a non active cell from active cell 1

Back
Top