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. |
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. |
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. |
All times are GMT +1. The time now is 02:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com