How to Use the IF Function in Excel 2007 With Absolute References. Cells in Excel are referred to using relative or absolute references. ... Open an Excel worksheet and add data to two columns, ...

How to use COUNTIF with a text condition. The COUNTIF function can also sum items based on text criteria. If you needed to find out how many items in a list have a particular color, you would do this: ...