Date Names Transaction Type Dr/Cr Amount
6/15/2021 Ram Online Dr 5000
6/16/2021 Sham Cash Cr 4500
6/17/2021 Sita Credit Card Dr 3000
6/18/2021 Gita Debit Card Cr 2000
6/19/2021 Rahul Online cr 12000
6/20/2021 Gagan Online Dr 11000
6/21/2021 Seema Debit Card Cr 4600
6/22/2021 Mohan Paytm Dr 5033
6/23/2021 Shivam Paytm Cr 7500
6/24/2021 Raj Debit Card Dr 1500
6/25/2021 Roopa Google Pay Cr 3640
6/26/2021 Vijay Cash dr 450
6/27/2021 Vishal Google Pay Dr 3644
6/28/2021 Rohit Paytm Dr 7500
total 71367
Date Names Transaction Type Dr/Cr Amount
6/15/2021 Ram Online Dr 5000
6/16/2021 Sham Cash Cr 4500
6/17/2021 Sita Credit Card Dr 3000
6/18/2021 Gita Debit Card Cr 2000
6/19/2021 Rahul Online cr 12000
6/20/2021 Gagan Online Dr 11000
6/21/2021 Seema Debit Card Cr 4600
6/22/2021 Mohan Paytm Dr 5033
6/23/2021 Shivam Paytm Cr 7500
6/24/2021 Raj Debit Card Dr 1500
6/25/2021 Roopa Google Pay Cr 3640
6/26/2021 Vijay Cash dr 450
6/27/2021 Vishal Google Pay Dr 3644
6/28/2021 Rohit Paytm Dr 7500
Transaction Type Dr Cr Transaction Type Dr/Cr
Online 16000 12000 Online 28000
Cash 450 4500 Cash 4950
Credit Card 3000 0 Credit Card 3000
Debit Card 1500 6600 Debit Card 8100
Paytm 12533 7500 Paytm 20033
Google Pay 3644 3640 Google Pay 7284
37127 34240 71367
Transaction Type
Online
Cash
Credit Card
Debit Card
Paytm
Google Pay
AVERAGE IF AVERAGE IFS
Names Transaction Type Dr/Cr Amount Transaction Type Dr/Cr Dr Cr Transaction Type
Ram Cash Dr 5000 Online 11500 11000 12000 Online
Sham Cash Cr 4500 Cash 4500 5000 4500 Cash
Sita Credit Card Dr 3000 Credit Card 1725 3000 450 Credit Card
Gita Debit Card Cr 2000 Debit Card 2700 1500 3300 Debit Card
Rahul Online cr 12000 Paytm 6677.66666667 6266.5 7500 Paytm
Gagan Online Dr 11000 Google Pay 3642 3644 3640 Google Pay
Seema Debit Card Cr 4600
Mohan Paytm Dr 5033
Shivam Paytm Cr 7500
Raj Debit Card Dr 1500
Roopa Google Pay Cr 3640
Vijay Credit Card Cr 450
Vishal Google Pay Dr 3644
Rohit Paytm Dr 7500
COUNT IF COUNT IFS
Dr Cr Dr/Cr
1 1 2
1 1 1
1 1 2
1 2 3
2 1 3
1 1 2
Date Names Transaction TDr/Cr Amount
6/15/2021 Ram Online Dr 5000
6/16/2021 Sham Cash Cr 4500
6/17/2021 Sita Credit Card Dr 3000
6/18/2021 Gita Debit Card Cr 2000
6/19/2021 Rahul Online cr 12000
6/20/2021 Gagan Online Dr 11000
6/21/2021 Seema Debit Card Cr 4600
6/22/2021 Mohan Paytm Dr 5033
6/23/2021 Shivam Paytm Cr 7500
6/24/2021 Raj Debit Card Dr 1500
6/25/2021 Roopa Google Pay Cr 3640
6/26/2021 Vijay Cash dr 450
6/27/2021 Vishal Google Pay Dr 3644
6/28/2021 Rohit Paytm Dr 7500
Total 71367
Names Gagan
Transaction Type Online
Dr/Cr Dr
Amount 11000
Date 6/15/2021 6/16/2021 6/17/2021 6/18/2021 6/19/2021 6/20/2021
Names Ram Sham Sita Gita Rahul Gagan
Transaction Type Online Cash Credit Card Debit Card Online Online
Dr/Cr Dr Cr Dr Cr cr Dr
Amount 5000 4500 3000 2000 12000 11000
Names Transaction Type Dr/Cr Amount
Seema Debit Card Cr 4600
6/28/2025 15:32
0°
30°
21 22 45°
23 24 60°
78 78 90°
35 36
6/21/2021 6/22/2021 6/23/2021 6/24/2021 6/25/2021 6/26/2021 6/27/2021 6/28/2021
Seema Mohan Shivam Raj Roopa Vijay Vishal Rohit
Debit Card Paytm Paytm Debit Card Google Pay Cash Google Pay Paytm
Cr Dr Cr Dr Cr dr Dr Dr
4600 5033 7500 1500 3640 450 3644 7500
198753 3456 195297
TIME/TEACHER RAM SHAM MOHAN SHAM
8:00 WORD MATH ENGLISH ### MATH
9:00 MATH EXCEL PHP
10:00 EXCEL POWER MATH
11:00 POWER BIOLOGY EXCEL
12:00 BIOLOGY TALLY POWER
13:00 TALLY JAVA BIOLOGY GVFHBGTGFF
14:00 JAVA PHP TALLY
15:00 PHP IELTS JAVA
BVGFGVBHNVGF
RTGCVF
FGRFH
TGBF
TIME/TEACHER RAM SHAM MOHAN MOHAN
8:00 WORD MATH PHP ### TALLY
9:00 MATH EXCEL WORD
10:00 EXCEL POWER MATH
11:00 POWER BIOLOGY EXCEL
12:00 BIOLOGY TALLY POWER
13:00 TALLY JAVA BIOLOGY
14:00 JAVA WORD TALLY
time time TRUE
