Ravi Sir's Cards › Excel
NGO Donor and Fund Management System in Excel (card 1 of 2)
Revision card 1 for NGO Donor and Fund Management System in Excel: Number of donations: =COUNTIFS(Donations!$C$5:$C$3000,A5) gives 2; Total given: =SUMIFS(Donations!$F$5:$F$3000,Donations!$C$5:$C$3000,A5) gives ₹35,000; Receipt number: ="ZF-"&TEXT(ROW()-4,"000") gives ZF-001. Includes an example data table.
Read card text
What this card says
1 for NGO Donor and Fund Management System in Excel: Number of donations: =COUNTIFS(Donations!$C$5:$C$3000,A5) gives 2
Total given: =SUMIFS(Donations!$F$5:$F$3000,Donations!$C$5:$C$3000,A5) gives ₹35,000
Receipt number: ="ZF-"&TEXT(ROW()-4,"000") gives ZF-001. Includes an
Example
data table
Learn this in the lesson: NGO Donor and Fund Management System in Excel: Donors, Donations, 80G Checks, Fund-wise Spending, Balance and Receipt