Counting text cells in Excel

  si_gone 20:43 23 Feb 2009
Locked

I am trying to count the number of occurances of a range of criteria in an Excel column. For instance, I need to find out how many cells in the column G75:G135 contain EITHER L, D, S, CE, CI, R, F, E, SP, G but NOT Z or blank. I could do it by doing =COUNTIF(G75:G135,"L")+COUNTIF(G75:G135,"D")+COUNTIF(G75:G135,"S")+COUNTIF(G75:G135,"CE")+COUNTIF(G75:G135,"CI"), etc, but I believe I can use DCOUNTA or a pivot table? If I use DCOUNTA, I have the key for L, D, S, etc on a seperate worksheet. However, I am confused what to use for Range, Field and Criteria. Additionally, I cannot find a satisfactory example to cover my particular use for a pivot table. Any help, anyone?

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?