Spreadsheet: 679626d1590526313-a-monthly-billing-total-over-numerous-sheets-for-product-types-test-for-sumif
Sheet: Health Hospital

DAILY BILLING LOG FOR BED RENTALS & BED RENT TO OWNS ONLY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Solace Gel PRI
OFFICE NAME: |  |  | New York |  |  |  | CUSTOMER NAME: | Health Hospital |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Matrix ALAL Control Unit
MONTH OF: |  |  | 2020-02-20 00:00:00 |  |  |  | CUSTOMER ID: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mattress topper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Posey Floor Cushions
 |  |  |  |  |  |  |  |  |  |  |  | Monthly Total: |  | 652.5
EQUIP. | BAR CODE | SERIAL | PRODUCT/ | PATIENT/ | P.O # | ROOM | ORIGINAL | THIS MO. | STOP | OPEN | DAILY | MONTHLY | TOTAL | TOTAL
ID |  | NUMBER | TYPE OF | DEPARTMENT |  | # | START | START | DATE | OR | RATE | CAP RATE | DAYS | FOR
 |  |  | EQUIPMENT |  |  |  | DATE | DATE |  | CLOSED |  |  | THIS MO. | MONTH
PFC | 26710276 | 26710276-1 | Fall mat |  | missing | 109 | 2017-04-14 00:00:00 |  |  |  |  |  | OPEN | OPEN
PFC | 26733441 | 26710178-1 | Posey Floor Cushions |  | missing | 95 | 2018-07-25 00:00:00 |  |  |  |  |  | OPEN | OPEN
 | 26717195 |  | Roll away bed | Standby |  |  | 2017-01-19 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
 | 26717219 |  | Roll away bed | Standby |  |  | 2017-01-19 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
 | 26717196 |  | Mattress topper | Standby |  |  | 2017-01-19 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
 | 26733376 |  | Mattress topper | Standby |  |  | 2017-01-19 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
 | 26733377 |  | Mattress topper | Standby |  |  | 2017-01-19 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
TEA | 26733094 | 5744 | Matrix ALAL C/U | Anonymous | Anonymous | 27 | 2018-02-12 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
TEAM | 26735345 | 16H4001324 | Matrix ALAL Mattress 42" | Anonymous | Anonymous | 27 | 2018-04-04 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 13 |  | 29 | 377
PDP5750 | 26732125 | 26732125-1 | Posey Defined Perimeter | Anonymous | Anonymous | 20.2 | 2018-08-31 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 1.5 |  | 29 | 43.5
KEA | 26708401 | 4679 | Matrix ALAL Control Unit | Anonymous | Anonymous | 30 | 2018-10-15 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
KEAM | 26736412 | 4253 | Matrix ALAL Low Profile42x80x8 | Anonymous | Anonymous | 30 | 2018-10-15 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 8 |  | 29 | 232
TEA | 26716627 | 6446 | Matrix ALAL C/U | Standby |  | missing | 2018-10-13 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
TEAM | 26739045 | 26739045-1 | Matrix ALAL Mattress | Standby |  | missing | 2018-10-13 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | OPEN | OPEN
 |  |  |  |  |  |  |  |  |  |  |  |  | OPEN | OPEN
 |  |  |  |  |  |  |  |  |  |  |  |  | OPEN | OPEN
 |  |  |  |  |  |  |  |  |  |  |  |  | OPEN | OPEN
 |  |  |  |  |  |  |  |  |  |  |  |  | OPEN | OPEN
 |  |  |  |  |  |  |  |  |  |  |  |  | OPEN | OPEN
 |  | Matrix ALAL Low Profile42x80x8 | 0 | D30 contains sumif function |  |  |  |  |  |  |  |  | OPEN | OPEN
 |  |  |  |  |  |  |  |  |  |  |  |  | OPEN | OPEN
 |  |  |  |  |  |  |  |  |  |  |  |  | OPEN | OPEN
 |  |  |  |  |  |  |  |  |  |  |  |  | OPEN | OPEN