Forum Discussion
Solved
Excel COUNTIF function not counting correctly
I've been using a sheet for a long time. Suddenly today, a simple COUNTIF function doesn't work any more. The formula is as simple as they get: =COUNTIF(AC23:SZ23,"L"). There are numerous 'L's in the...
- There might be L’s with leading and trailing spaces. Try this:
=SUMPRODUCT(—(TRIM(AC23:SZ23)=“L”))
My counties not counting
I used = counties(Gender, male, GPA,''>''&3.2) I have been working on it for some hours I could not get what I want?
I used = counties(Gender, male, GPA,''>''&3.2) I have been working on it for some hours I could not get what I want?