You may be well-accustomed to using cell references in Excel, but did you know you could go one step further and create your ... want to count text as well as numbers, use the COUNTA function ...

Excel's COUNT function produces a number of cells containing any value ... text or conditions, turning your spreadsheet chaos ...

In this article we’ll look at five useful types of formulas and functions that will get ... your data. Using this function, you can have Excel perform a calculation or display a certain value ...

Have you ever put together an Excel ... text to 0 if it has no other way of evaluating your formula. The simplest way to deal with this issue is to make sure that all your data is stored as numbers, ...

Your function combo would read: However, things get a little more intricate if your column contains text ... will not count towards the running total of unique values, as there is no value to ...

From the Not Just Numbers blog: Just a short little tip this week, due to a hectic diary. When you reference a cell in Excel, you will get its value, but what if you ... themselves), or to return the ...