This is my current code:
=COUNTIF(C$8:C$31,"=A50*")
A50, should be a letter from another cell. For example right now A50 is A. The code used to look like this, but I want to make it easier for multiple letters. =COUNTIF(C$8:C$31,"=A*")
This is my current code:
=COUNTIF(C$8:C$31,"=A50*")
A50, should be a letter from another cell. For example right now A50 is A. The code used to look like this, but I want to make it easier for multiple letters. =COUNTIF(C$8:C$31,"=A*")
Try
=COUNTIF(C$8:C$31,A50&"*")
Dunno if I understood this correctly.
Try
=COUNTIF(C$8:C$31,A50&"*")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks