Counting text cells in Excel

  si_gone 20:43 23 Feb 09
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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced