Hi everyone,

I need some help with a formula, the formula will look at the "U" column and "J" column and if it meets both conditions it will add a 1.
I need this formula to look at "J" column and meet the condition not only for Vancouver but for other cities as well, so that if J = Vancouver add 1, or Montreal add 1, etc.
can some one help?

=IF(AND(U:U="Notebook computer",J:J ="Vancouver",I:I="Deployed"),1,0)