Sum cells based on Cell Background color. If you have marked the background color of Cells containing numbers in various colors based on some criteria and you want sum the values of these cells for each separate color then this util will help you.
Sum cells based on Cell Font color. If you have marked the font color of Cells containing numbers in various colors based on some criteria and you want sum the values of these cells for each separate color then this util will help you.
Count cells based on Cell Background color. If you have marked the background color of Cells containing numbers in various colors based on some criteria and you want to count the number of these cells for each separate color then this util will help you.
Count cells based on Cell Font color. If you have marked the font color of Cells containing numbers in various colors based on some criteria and you want to count the number of these cells for each separate color then this util will help you.
Statistical data: Count the number of data in a selected area in between a minimum & maximum value.
Suppose you have a data range like this.
3 |
8 |
17 |
34 |
13 |
19 |
12 |
17 |
22 |
16 |
19 |
13 |
18 |
21 |
17 |
12 |
12 |
9 |
15 |
14 |
12 |
19 |
15 |
17 |
Now you want to know the count for all data between 20 & 30. Do the following. First type the following
|
Max |
Number |
20 |
30 |
|
Now go to the cell where you want the count ie. under Number and call this program. You will get a screen like this.
In the 1st edit select the range of data where the data has to be searched. In the 2nd edit box select the cell containing the Min value (Do not use values, only cell reference is allowed). In the 3rd edit box put the cell reference of max value and then click Put Formula. and the formula put will be =rangedata(Sheet1!$A$1:$C$8,Sheet1!A11,Sheet1!B11) and its value will be 3.