Adding errors, texts, numbers, blanks in a list

A quick post.

Here is how you can you can count errors, blanks, numbers, texts in a list.

List A2:A11 is defined as Count_list

To count

• Errors       {=SUM(IF(ISERROR(Count_list),1,0))}
• Blanks       {=SUM(IF(ISBLANK(Count_list),1,0))}
• Numbers {=SUM(IF(ISNUMBER(Count_list),1,0))}
• Text           {=SUM(IF(ISTEXT(Count_list),1,0))}

The formulas are entered as array formuals with ctrl+shift+enter

Read Full Post »

Populate blank rows

Populate blank rows so that they can be filtered or conditionally added

For eg. Zone wise sales figure is given but zone is not populated in each row making it difficult to sum sales figures zone-wise
Data as given in Table 1

E2 = A2

E3 = IF(ISBLANK(A3),E2,A3)

This populates all the blank rows of the table

Read Full Post »