Ravi Sir's Cards › Excel
Photography Studio Management System in Excel (card 2 of 2)
Revision card 2 for Photography Studio Management System in Excel: Balance: =L5-M5 gives ₹9,940; Paid so far: =SUMIFS(Payments!$C$5:$C$2000,Payments!$B$5:$B$2000,A5) gives ₹88,000; Bookings per photographer: =COUNTIF(Bookings!$F$5:$F$500,A5) gives 3. Includes an example data table.
Read card text
What this card says
2 for Photography Studio Management System in Excel: Balance: =L5-M5 gives ₹9,940
Paid so far: =SUMIFS(Payments!$C$5:$C$2000,Payments!$B$5:$B$2000,A5) gives ₹88,000
Bookings per photographer: =COUNTIF(Bookings!$F$5:$F$500,A5) gives 3. Includes an
Example
data table
Learn this in the lesson: Photography Studio Management System in Excel: Packages, Bookings, Date Clash Check, Delivery Tracking and Dashboard