| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i give formula to count the only numbers except zero in a
Hi!
I need to put a formula so that it counts the numbers in a cell without considering zero.If in a column there in a1=4,a2=3,a3=0 It should return the value as 2.Please let me knoe the answer for this problem.My mail id is Thanks, Anu |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i give formula to count the only numbers except zero in a
Anu
=COUNTIF(A:A,"0") Regards Trevor "Anuja" wrote in message ... Hi! I need to put a formula so that it counts the numbers in a cell without considering zero.If in a column there in a1=4,a2=3,a3=0 It should return the value as 2.Please let me knoe the answer for this problem.My mail id is Thanks, Anu |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i give formula to count the only numbers except zero i
hi!
But if the column contains the alphabets all the other it should only discard the zero how can it be Regards, Anu "Trevor Shuttleworth" wrote: Anu =COUNTIF(A:A,"0") Regards Trevor "Anuja" wrote in message ... Hi! I need to put a formula so that it counts the numbers in a cell without considering zero.If in a column there in a1=4,a2=3,a3=0 It should return the value as 2.Please let me knoe the answer for this problem.My mail id is Thanks, Anu |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i give formula to count the only numbers except zero i
Try a sumproduct:
=SUMPRODUCT(--ISNUMBER(A1:A3),--(A1:A3<0)) Anuja wrote: hi! But if the column contains the alphabets all the other it should only discard the zero how can it be Regards, Anu "Trevor Shuttleworth" wrote: Anu =COUNTIF(A:A,"0") Regards Trevor "Anuja" wrote in message ... Hi! I need to put a formula so that it counts the numbers in a cell without considering zero.If in a column there in a1=4,a2=3,a3=0 It should return the value as 2.Please let me knoe the answer for this problem.My mail id is Thanks, Anu |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i give formula to count the only numbers except zero i
One way:
=SUMPRODUCT((A1:A100=1)*(A1:A100<=9)) Regards Trevor "Anuja" wrote in message ... hi! But if the column contains the alphabets all the other it should only discard the zero how can it be Regards, Anu "Trevor Shuttleworth" wrote: Anu =COUNTIF(A:A,"0") Regards Trevor "Anuja" wrote in message ... Hi! I need to put a formula so that it counts the numbers in a cell without considering zero.If in a column there in a1=4,a2=3,a3=0 It should return the value as 2.Please let me knoe the answer for this problem.My mail id is Thanks, Anu |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i give formula to count the only numbers except zero i
Hi!
The column should accept all the things like alphabets,sp.char,numbers but should discard only zero.I am sorry for asking once again.Please let me know the answer.Please. Thanks and Regards, Anu "Trevor Shuttleworth" wrote: One way: =SUMPRODUCT((A1:A100=1)*(A1:A100<=9)) Regards Trevor "Anuja" wrote in message ... hi! But if the column contains the alphabets all the other it should only discard the zero how can it be Regards, Anu "Trevor Shuttleworth" wrote: Anu =COUNTIF(A:A,"0") Regards Trevor "Anuja" wrote in message ... Hi! I need to put a formula so that it counts the numbers in a cell without considering zero.If in a column there in a1=4,a2=3,a3=0 It should return the value as 2.Please let me knoe the answer for this problem.My mail id is Thanks, Anu |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i give formula to count the only numbers except zero i
The question you posed was "How can I give formula to count the *only
numbers* except zero" Whatever, try this: =COUNTIF(A1:A15,"<0") Regards Trevor "Anuja" wrote in message ... Hi! The column should accept all the things like alphabets,sp.char,numbers but should discard only zero.I am sorry for asking once again.Please let me know the answer.Please. Thanks and Regards, Anu "Trevor Shuttleworth" wrote: One way: =SUMPRODUCT((A1:A100=1)*(A1:A100<=9)) Regards Trevor "Anuja" wrote in message ... hi! But if the column contains the alphabets all the other it should only discard the zero how can it be Regards, Anu "Trevor Shuttleworth" wrote: Anu =COUNTIF(A:A,"0") Regards Trevor "Anuja" wrote in message ... Hi! I need to put a formula so that it counts the numbers in a cell without considering zero.If in a column there in a1=4,a2=3,a3=0 It should return the value as 2.Please let me knoe the answer for this problem.My mail id is Thanks, Anu |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i give formula to count the only numbers except zero i
Hi!
Thanks a lot . Trevor it was useful for me very much.Thanks a lot once again Regards, Anu "Trevor Shuttleworth" wrote: The question you posed was "How can I give formula to count the *only numbers* except zero" Whatever, try this: =COUNTIF(A1:A15,"<0") Regards Trevor "Anuja" wrote in message ... Hi! The column should accept all the things like alphabets,sp.char,numbers but should discard only zero.I am sorry for asking once again.Please let me know the answer.Please. Thanks and Regards, Anu "Trevor Shuttleworth" wrote: One way: =SUMPRODUCT((A1:A100=1)*(A1:A100<=9)) Regards Trevor "Anuja" wrote in message ... hi! But if the column contains the alphabets all the other it should only discard the zero how can it be Regards, Anu "Trevor Shuttleworth" wrote: Anu =COUNTIF(A:A,"0") Regards Trevor "Anuja" wrote in message ... Hi! I need to put a formula so that it counts the numbers in a cell without considering zero.If in a column there in a1=4,a2=3,a3=0 It should return the value as 2.Please let me knoe the answer for this problem.My mail id is Thanks, Anu |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How do I create formula to count numbers in a range of cells? | Excel Worksheet Functions | |||
Linear Mode
