Ravi Sir's Cards › Excel
Home Inventory in Excel (card 2 of 2)
Revision card 2 for Home Inventory in Excel: Total value of all items: =SUM(D6:D14) gives ₹2,41,289; Items still under warranty: =COUNTIF(H6:H14,"Active")+COUNTIF(H6:H14,"Expiring soon") gives 6. Includes an example data table.
Read card text
What this card says
2 for Home Inventory in Excel: Total value of all items: =SUM(D6:D14) gives ₹2,41,289
Items still under warranty: =COUNTIF(H6:H14,"Active")+COUNTIF(H6:H14,"Expiring soon") gives 6. Includes an
Example
data table
Learn this in the lesson: Home Inventory in Excel: Appliance List with Warranty Expiry Dates and Alerts (EDATE)