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

DAILY BILLING LOG FOR BED RENTALS & BED RENT TO OWNS ONLY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Solace Gel PRI
OFFICE NAME: |  |  | New York |  |  |  | CUSTOMER NAME: | Health Nursing Home |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Matrix ALAL Control Unit
MONTH OF: |  |  | 2020-02-20 00:00:00 |  |  |  | CUSTOMER ID: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mattress topper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Posey Floor Cushions
 |  |  |  |  |  |  |  |  |  |  |  | Monthly Total: |  | 824
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
KEA | 26740008 | 17L4001576 | Matrix ALAL Control Unit | Anonymous |  | 212 | 2019-11-01 00:00:00 | 2020-02-01 00:00:00 | 2020-02-01 00:00:00 | CLOSED | 0 |  | 1 | 0
KA36808 | 26742580 | 26742580-1 | Matrix ALAL Low Profile36x80x8 | Anonymous |  | 212 | 2019-11-01 00:00:00 | 2020-02-01 00:00:00 | 2020-02-01 00:00:00 | CLOSED | 8 |  | 1 | 8
GIS35802 | 26733788 | 26733788-1 | Solace Gel PRI | Anonymous |  | 212 | 2019-11-01 00:00:00 | 2020-02-01 00:00:00 | 2020-02-01 00:00:00 | CLOSED | 4 |  | 1 | 4
GIS35802 | 26736074 | 26736074-1 | Solace Gel PRI | Standby |  |  | 2019-11-04 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
KEA | 26740032 | 17L4001600 | Mattress topper | Anonymous |  | 619 | 2019-12-17 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
KA368010 | 26742523 | 19B4001866 | Matrix ALAL Mattress 36x80x10 | Anonymous |  | 619 | 2019-12-17 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 8 |  | 29 | 232
GIS35802 | 26736062 | 26736062-1 | Solace Gel PRI | Anonymous |  | 619 | 2019-12-17 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 4 |  | 29 | 116
TEA | 26732359 | 4337 | Matrix ALAL Control Unit | Anonymous |  | 619 | 2019-12-17 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
KA368010 | 26742516 | 19B4001868 | Matrix ALAL Mattress 36x80x10 | Anonymous |  | 619 | 2019-12-17 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 8 |  | 29 | 232
KEA | 26701919 | 4434 | Matrix ALAL Control Unit | Anonymous |  | 607 | 2019-12-27 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
AA358410 | 26736460 | 26719701-1 | Matrix ALAL Mattress 35x84x10 | Anonymous |  | 607 | 2019-12-27 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 8 |  | 29 | 232
KEA | 26709198 | 4207 | Matrix ALAL Control Unit | Standby |  |  | 2020-01-03 00:00:00 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | OPEN | 0 |  | 29 | 0
KA36808 | 26740929 | 4481 | Matrix ALAL Low Profile36x80x8 | Standby |  |  | 2020-01-03 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
 |  |  |  |  |  |  |  |  |  |  |  |  | OPEN | OPEN
 |  |  |  |  |  |  |  |  |  |  |  |  | OPEN | OPEN