| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count them number of cells between values -2 and 2 including 0
I have a list of data I would like to count the number of cells that have the
following data -2, -1, 0, 1, 2. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count them number of cells between values -2 and 2 including 0
=SUMPRODUCT(--(A1:A10=-2),--(A1:A10<=2)) will give total number of cells
with value between -2 to +2 For individual counts: =COUNTIF(A1:A10,"=-2") etc HTH "Helppppppppppppppppppppppppppppp" wrote: I have a list of data I would like to count the number of cells that have the following data -2, -1, 0, 1, 2. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count them number of cells between values -2 and 2 including 0
Hi!
Try one of these: =COUNTIF(A1:A10,"=-2")-COUNTIF(A1:A10,"2") =SUMPRODUCT(--(ISNUMBER(A1:A10)),--(A1:A10=-2),--(A1:A10<=2)) Biff "Helppppppppppppppppppppppppppppp" osoft.com wrote in message ... I have a list of data I would like to count the number of cells that have the following data -2, -1, 0, 1, 2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| How do I use countif to count values excluding blank cells | Excel Worksheet Functions | |||
| how to count number of cells in a color ? | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| How do I count the number of cells in a list, e.g. H6:H12, J4, J7: | Excel Worksheet Functions | |||
Linear Mode
