View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jshuatree jshuatree is offline
external usenet poster
 
Posts: 1
Default Countif with nested function not working?


I'm attempting a countif that reads - COUNTIF(A:A,LEFT(A:A,1)=X)
Where column A looks something like:
XYZ
MNOP
XMN
LKJ
XTR

What's the proper way to do this?
Thanks!


--
jshuatree
------------------------------------------------------------------------
jshuatree's Profile: http://www.excelforum.com/member.php...o&userid=36459
View this thread: http://www.excelforum.com/showthread...hreadid=562227