Ifg I understand this: The easy way out, for setup and maintenance, is a
helper column. Let us for this humble sample select column K. Enter in K4
=E4&I4
fill down, and do either a countif or a pivot table on that column.

HTH. Best wishes Harald

"Warren1872" skrev i melding
...
I'm wanting to have a box count the total number of times a C and W
appear, C
and L, P and W, and P and L. I've tried using the CountIF, and can get
the
proper result for how many times one character shows up in one column (aka
number of W's), but am trying to get a result where everytime a C and W
appear, it will add one to the C and W box (where ? are located below.)

The current formulas I've tried are...

=COUNTIF(E4:E180,"C")&COUNTIF(I4:I48,"W")
=COUNT(IF(E4:E180="C",1,0),IF(I4:I48="W",1,0))


C P&C 03/03/2005 30,000 W
P EBS 03/04/2005 50,000 W
P EBS
C P&C (225,000) L
P P&C W
P Env. 04/20/2005
C P&C 03/24/2005 W


Running Totals W L

# Clients ? ?

Any ideas of how to link these two columns together to dispaly a result in
a
different cell?

--
Thanks, Warren