count data of multiple rows independently

[tandon]

Hello,

I am new to access and trying to count data in different row using COUNT function with WHERE clause , but getting error---> Can not have aggregate function withn WHERE, Need to count data which matches either of the given conditions ,
PLEASE HELP!!!