Are you saying you want to count (A>625)+(B begins with ca)+(c begins with ca)
Regardless if those 3 creteria occur on the same row??
then it's
=COUNTIF(A:A,">625")+COUNTIF(B:B,"ca*")+COUNTIF(C:C,"ca*")
Are you saying you want to count (A>625)+(B begins with ca)+(c begins with ca)
Regardless if those 3 creteria occur on the same row??
then it's
=COUNTIF(A:A,">625")+COUNTIF(B:B,"ca*")+COUNTIF(C:C,"ca*")
There are currently 2 users browsing this thread. (0 members and 2 guests)
Bookmarks