Count if and expression

[#1]

I am having trouble creating a count if and expression in my analysis.

I am looking to get the count if Field1 if Field2 = Yes, and Filed3 = 4

=Count(if(Field2='Yes',and(Field3=4))Field1)

[swuehl · Accepted solution]

Maybe

=Count( if(Field2='Yes' and Field3=4 , Field1))

[Anonymous]

Hi,

Your expression is wrong.

Try this:

=Count(if(Field2='Yes' and Field3=4,Field1))

[#4]

That worked.. thank you