Need to automate a table showing the total number of times the numbers are less than 18 and greater than 18 for each time per day. I tried ding this =COUNTIF(Data!C2:C395,"Morning")*COUNTIF(Data!D2:D395,"<18") but not working.
| the project.xlsx | |||||
|---|---|---|---|---|---|
| V | W | X | |||
| 4 | Time | Less Than 18 | Greater Than 18 | ||
| 5 | Morning | 14344 | 0 | ||
| 6 | Midday | 0 | 0 | ||
| 7 | Afternoon | 0 | 0 | ||
| 8 | Evening | 0 | 0 | ||
Overview | |||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| W5 | W5 | =COUNTIF(Data!C2:C395,"Morning")*COUNTIF(Data!D2:D395,"<18") |
| X5:X8 | X5 | =COUNTIF(Data!D:D, "Morning") - COUNTIF(Data!E:E, "<18") |
| W6:W8 | W6 | =COUNTIF(Data!C3:C396,"Morning")*COUNTIF(B3:B101,"<18") |
| the project.xlsx | |||||
|---|---|---|---|---|---|
| B | C | D | |||
| 1 | Date | Time | Num | ||
| 2 | 2-Jan-23 | Morning | 33 | ||
| 3 | 2-Jan-23 | Midday | 21 | ||
| 4 | 2-Jan-23 | Afternoon | 4 | ||
| 5 | 2-Jan-23 | Evening | 1 | ||
| 6 | 3-Jan-23 | Morning | 2 | ||
| 7 | 3-Jan-23 | Midday | 15 | ||
| 8 | 3-Jan-23 | Afternoon | 32 | ||
| 9 | 3-Jan-23 | Evening | 22 | ||
| 10 | 4-Jan-23 | Morning | 27 | ||
| 11 | 4-Jan-23 | Midday | 5 | ||
| 12 | 4-Jan-23 | Afternoon | 32 | ||
| 13 | 4-Jan-23 | Evening | 35 | ||
| 14 | 5-Jan-23 | Morning | 18 | ||
| 15 | 5-Jan-23 | Midday | 12 | ||
| 16 | 5-Jan-23 | Afternoon | 15 | ||
| 17 | 5-Jan-23 | Evening | 11 | ||
| 18 | 6-Jan-23 | Morning | 19 | ||
| 19 | 6-Jan-23 | Midday | 12 | ||
| 20 | 6-Jan-23 | Afternoon | 2 | ||
| 21 | 6-Jan-23 | Evening | 20 | ||
| 22 | 7-Jan-23 | Morning | 36 | ||
| 23 | 7-Jan-23 | Midday | 36 | ||
| 24 | 7-Jan-23 | Afternoon | 5 | ||
| 25 | 7-Jan-23 | Evening | 20 | ||
| 26 | 9-Jan-23 | Morning | 32 | ||
| 27 | 9-Jan-23 | Midday | 13 | ||
| 28 | 9-Jan-23 | Afternoon | 5 | ||
| 29 | 9-Jan-23 | Evening | 21 | ||
| 30 | 10-Jan-23 | Morning | 18 | ||
| 31 | 10-Jan-23 | Midday | 5 | ||
Data | |||||
