How to (syntax) for a Count(if(List='one',List2='blue', items))

[#1]

I´m trying to make a count with 2 criteria that needs to be true, - but the above does´nt work

[gauravkhare · Accepted solution]

hi,

try out using the and condition as it will definately help solving your problem.

[#3]

Found solution just use AND instead of the comma between the 2 criteria

[#4]

Thanx Gaurav

[lironbaram]

hei there

1. count(if(List='one' and List2='blue',items))