I'm not sure I phrased this title correctly. Please feel welcome to offer suggested edits.

I have data formatted like so:

```
Token,Location,Quantity
VBD,IN,100
NN,IN,200
FD,OUT,300
VBD,OUT,300
NN,OUT,400
NN,IN,100
```

Ultimately, I would like to perform t-tests on the Quantity of each Token, comparing IN and OUT. Is there a way to do this without filtering for each, and performing a t-test?

**EDIT**

The t-test part isn't relevant, per se, I'm just looking to insert a range into a formula. The =TTEST function, for example, takes the following arguments: `TTEST(array1,array2,tails,type)`

. If I wanted rows 2 and 6 in `Array1`

(NN,IN), and row 5 in `Array2`

, is there a formula I use within the `TTEST`

formula, in lieu of selecting the cells?

1more comment