Ravi Sir's Cards › Excel
Cloud Kitchen Management System in Excel (card 2 of 2)
Revision card 2 for Cloud Kitchen Management System in Excel: Net after commission, food and packaging: =F5-H5-I5-J5 gives ₹99.00; Orders per channel: =COUNTIF(Orders!$C$5:$C$5000,A5) gives 143; Net per channel: =SUMIFS(Orders!$K$5:$K$5000,Orders!$C$5:$C$5000,A5) gives ₹18,445.
Read card text
What this card says
2 for Cloud Kitchen Management System in Excel: Net after commission, food and packaging: =F5-H5-I5-J5 gives ₹99.00
Orders per channel: =COUNTIF(Orders!$C$5:$C$5000,A5) gives 143
Net per channel: =SUMIFS(Orders!$K$5:$K$5000,Orders!$C$5:$C$5000,A5) gives ₹18,445.
Learn this in the lesson: Cloud Kitchen Management System in Excel: Menu Costing, Orders, App Commission, Net Margin and Dashboard