[ResponsiveRect] Count the number of products of a particular Brand. Criteria Range Is E23:E24 DATABASE FORMULA – DCOUNTA Function What Does It Do ? This function examines a list of information and counts the non blank cells in a specified column. It counts values and text items, but blank cells are ignored. Syntax =DCOUNTA(DatabaseRange,FieldName,CriteriaRange) Description … Read more
[ResponsiveRect] How many boxes of a particular item do we have in stock? Criteria Range Is C23:F24 DATABASE FORMULA – DGET Function What Does It Do ? This function examines a list of information and produces one result. If more than one record matches the criteria the error #NUM is shown. If no records match … Read more
Text FORMULA – CHAR Function [ResponsiveRect] What Does It Do? This function converts a normal number to the character it represent in the ANSI character set used by Windows. Syntax =CHAR(Number) The Number must be between 1 and 255. Formatting The result will be a character with no special formatting. Example The following is a … Read more
Text Formulas – Clean Function [ResponsiveRect] What Does It Do – Clean Function? This function removes any nonprintable characters from text. These nonprinting characters are often found in data which has been imported from other systems such as database imports from mainframes. Syntax =CLEAN(TextToBeCleaned) Formatting No special formatting is needed. The result will show as normal … Read more