Hi,

I have checked the FAQ's and searched the threads to no avail. Basically I need these two formulas.

COUNTA(range)if COUNTA(range="text") and COUNTBLANK(range)if COUNTA(range="text")

Counting the number of cells in a column that contain text related to text entries in another column and counting the blank cells in a column relating to text entries in another column. It sounds simple but I cannot find a function or array combination that works. The entries I refer to change daily and there are thousands of them. I currently do it by hand, (inserting rows and resorting and changing the range in the formula bar) This is VERY time consuming. I would like to be able to just add a new entry anywhere in the list and let the formula do the work.

Thanks in advance

## Bookmarks