Ravi Sir's Cards › Excel
Interior Design Costing System in Excel (card 1 of 2)
Revision card 1 for Interior Design Costing System in Excel: Rate per unit: =C10+D10 gives ₹1,800; Line amount: =E5+F5 gives ₹1,53,000; Estimate per room: =SUMIFS(Estimate!$G$5:$G$500,Estimate!$A$5:$A$500,A5) gives ₹1,61,480.

Read card text
What this card says
1 for Interior Design Costing System in Excel: Rate per unit: =C10+D10 gives ₹1,800
Line amount: =E5+F5 gives ₹1,53,000
Estimate per room: =SUMIFS(Estimate!$G$5:$G$500,Estimate!$A$5:$A$500,A5) gives ₹1,61,480.
Learn this in the lesson: Interior Design Costing System in Excel: Rate Card, Room Estimate, Budget vs Actual, Payment Schedule and Quotation