Ravi Sir's Cards › Excel
Expense Reimbursement System in Excel (card 2 of 2)
Revision card 2 for Expense Reimbursement System in Excel: Claimed per employee: =SUMIFS(Claims!$H$5:$H$3000,Claims!$C$5:$C$3000,A5) gives ₹4,630; Allowed per category: =SUMIFS(Claims!$J$5:$J$3000,Claims!$E$5:$E$3000,A14) gives ₹3,780; Cut by limits: =SUM(Claims!$H$5:$H$3000)-SUM(Claims!$J$5:$J$3000) gives ₹4,450. Includes an example data table.
Read card text
What this card says
2 for Expense Reimbursement System in Excel: Claimed per employee: =SUMIFS(Claims!$H$5:$H$3000,Claims!$C$5:$C$3000,A5) gives ₹4,630
Allowed per category: =SUMIFS(Claims!$J$5:$J$3000,Claims!$E$5:$E$3000,A14) gives ₹3,780
Cut by limits: =SUM(Claims!$H$5:$H$3000)-SUM(Claims!$J$5:$J$3000) gives ₹4,450. Includes an
Example
data table
Learn this in the lesson: Expense Reimbursement System in Excel: Claims, Km Rates, Category Limits, Bill Check, Approval and Payment Status