Selecting certain data using IF statements in pivot table

[mlaurab]

Hello, I am currently using a pivot table to organize my data. I want take the average of certain numbers in a column only IF the column next to it corresponds to FALSE. Is this possible? For example:

A1(NUMBERS) A2(USE)

2 FALSE

3 TRUE

5 FALSE




So I only would want to take the average between 2 and 5. Thank you so much!

 

[ParamRay]

Hello. If the numbers are in column A, and the TRUE/FALSE values are in column B, you can use a formula such as:

= AVERAGEIF( B:B, FALSE(), A:A )