Find average when other column reads "true"

[mark91345]

Using Office 365 on Windows 10,
When column A is TRUE, I want to find the Average of column B. I know I use could Filter, but I want to create a formula instead. Can someone help?

ASC.xlsx
	A	B
1	T/F	Price
2	FALSE	0.32
3	FALSE	0.49
4	FALSE	0.59
5	FALSE	0.20
6	FALSE	0.61
7	FALSE	0.21
8	TRUE	0.19
9	FALSE	0.33
10	FALSE	0.02
11	TRUE	0.11
12	TRUE	0.00
13	TRUE	0.43
14	TRUE	0.04
15	TRUE	0.28
16	FALSE	0.57
17	FALSE	0.59
18	FALSE	0.00
19	TRUE	0.21
20	FALSE	0.52
21	FALSE	0.08
22	TRUE	0.38
23	TRUE	0.59
24	FALSE	0.72
25	FALSE	0.10
test

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A25	Cell Value	contains "TRUE"	text	NO

 

[maabadi]

How about AverageIF:

Book1
	A	B	C	D	E	F
1	T/F	Price			AVERAGEIF
2	FALSE	0.32			0.247777778
3	FALSE	0.49
4	FALSE	0.59
5	FALSE	0.2
6	FALSE	0.61
7	FALSE	0.21
8	TRUE	0.19
9	FALSE	0.33
10	FALSE	0.02
11	TRUE	0.11
12	TRUE	0
13	TRUE	0.43
14	TRUE	0.04
15	TRUE	0.28
16	FALSE	0.57
17	FALSE	0.59
18	FALSE	0
19	TRUE	0.21
20	FALSE	0.52
21	FALSE	0.08
22	TRUE	0.38
23	TRUE	0.59
24	FALSE	0.72
25	FALSE	0.1
26
Sheet1

Cell Formulas
Range	Formula
E2	E2	=AVERAGEIF($A$2:$A$25,"TRUE",$B$2:$B$25)

 

[mark91345]

Of Course! I don't know why it hadn't occurred to me. Thank you so much.

 

[maabadi]

You're Welcome & Thanks for Feedback.