View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gma gma is offline
external usenet poster
 
Posts: 45
Default x = 1 or a value

thanks

"Stefi" wrote:

Insert this formula in the required result cell:

=COUNTIF(A1:A3,"X")

Adjust range as needed!

Regards,
Stefi

€˛gma€¯ ezt Ć*rta:

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?