Hi All,
I am having trouble creating a formula...
I need the sum of verbal phone orders between 7:01AM and 11:59PM....I counted 10 (data is below)
I started with the formula below, but maybe I should use SUMIFS? Or what formula can I use to get me the sum of verbal phone orders between 7:01AM and 11:59PM?
<colgroup><col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;">
<tbody>
</tbody>
<colgroup><col width="64" style="width: 48pt;">
<col width="103" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;" span="3">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
I am having trouble creating a formula...
I need the sum of verbal phone orders between 7:01AM and 11:59PM....I counted 10 (data is below)
I started with the formula below, but maybe I should use SUMIFS? Or what formula can I use to get me the sum of verbal phone orders between 7:01AM and 11:59PM?
COUNTIFS (F:F,">0",D:D,">7:00AM",D:D,"<12:00AM") |
B | D | E | F | |
Order Date | Order Time | Pharm Orders | Verbal Phone Orders | |
4 | 2/12/2019 | 6:48 AM | 1 | 1 |
5 | 2/12/2019 | 6:49 AM | 1 | 1 |
6 | 2/12/2019 | 6:54 AM | 2 | 2 |
7 | 2/27/2019 | 8:36 AM | 1 | 1 |
8 | 2/26/2019 | 9:34 AM | 1 | 1 |
9 | 2/26/2019 | 9:40 AM | 1 | 1 |
10 | 2/28/2019 | 10:09 AM | 3 | 3 |
11 | 2/13/2019 | 2:38 PM | 1 | 1 |
12 | 2/12/2019 | 7:00 PM | 1 | 1 |
13 | 2/5/2019 | 8:14 PM | 2 | 2 |
14 | 2/7/2019 | 3:33 PM | 9 | 0 |
15 | 2/20/2019 | 12:01 PM | 9 | 0 |
16 | 2/22/2019 | 10:50 AM | 9 | 0 |