Count If S

[brookr1988]

Good morning.
I am wanting a forumala that will count if values are above 0.15 and if they appear in a truncated list.
i.e I have two lists of letters, one a master list which has associated values and one truncated which does not.



Master Lists Truncated List Answer = 2 (A is in the truncated list, and is above 0.15, same for B, D and E appear in the list but values are below 0.15)
A 0.2 A
B 0.2 B
C 0.2 D
D 0 E
E 0
F 0
G 0
H 0
I 0.2

I am wanting to do this in a single equation as opposed to seperating out columns and vlookups etc.
Any help would be appreciated.
Please ket me know if you need more information

[JohnTopley]

Try

=SUM(COUNTIFS(A1:A9,C1:C4,B1:B9,">0.15"))


...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Data in A1:B9 and C1:C4

[brookr1988]

Thanks that worked perfectly!