Excel Formulas : Advance

A daily exercise in the Excel to make a better future makes you learn a lot of formulas these are those !

https://gefintech.blogspot.com/2025/01/excel-formulas-advance.html

1. SUMIF Function 

Use Case : to sum a particular category from the n numbers of catergories available 

For eg. 

1. Types of Liabilities : Term Loan, ECB and NCD
2. Amounts for the type of Liabilities 

We want to sum only Term Loam 

Formula 

SUMIF(Range = Type of Liabilities,Criteria = "Term Loan",Sum Range = Amounts of type of Liabilities)


Comments

Post a Comment

Popular posts from this blog

Financial Modelling for Project Finance

Image
Financial Modelling for a Project Finance is not a easy thing, we will here do the most basic of that.  While in real life project real life problems come like taxation, sensitivity analsysis and all, but this model is prepared by me in the most simplistic and basic level of Project Finance that too with referrence to Renewable Energy Sector. In the first step will be timelines  The start comes from writing down the assumption that is Construction and Operations period,  the Construction Period starts from 1st Jan 2023 and the end date will be withing one year that I took as a year (=Eomonth(Start date,12)).  the Opeartion Period start after the Construction Period that is 31st Jan 2023 and will be 1st Jan 2024 (=edate(startd ate,12)) Then we will start with the quarterly start and end of the periods that can be seen in dark blue by Quarter 1 (Start Date will be 1st Jan 23 and End of the period will be =Eomonth(Start date,3-1)  then the next quarter 2 start da...
Read more