Madonna House, Westlands Road - Nairobi

Category: Functions & Formulas

SUMIF Excel Function

How to use the Excel SUMIF Function

Description The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 2000). The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a…
Read more

Guidelines and examples of array formulas Tutorial

Applies to: Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel for iPad Excel for iPhone An array formula is a formula that can perform multiple calculations on one or more items in an array. You can think of an array as…
Read more

3 Statement Financial Model Template

This free template includes assumptions, an income statement, a balance sheet, a cash flow statement, and a supporting schedules section to calculate depreciation, amortization, and interest on the debt.