| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
x = 1 or a value
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
x = 1 or a value
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
x = 1 or a value
thanks mike
"Mike H" wrote: 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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
x = 1 or a value
You are welcome! Thanks for the feedback!
Stefi €˛gma€¯ ezt Ć*rta: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
