Hello I am wanting to count 5 columns in 1 row i want to check if they are over 23 and even.
I have =COUNTIFS(B2:F2,">23",B2:F2,SUMPRODUCT((MOD(B2:F2,2)=0)+0)).
Not sure if this is the correct way to do it as I got 0 when it should be 1.
Any help would be appreciated thank you
Bookmarks