Thread: x = 1 or a value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default x = 1 or a value
Try

=COUNTIF(A1:A27,"x")

Mike

"gma" wrote:

I want to put a "X" in a cell and had that total a number
colume a
1 X
2 X
3 X
total 3

how do i do that or can it be done?
Reply With QuoteReply With Quote