For your running total for 'c' and 'w' use
=SUMPRODUCT(--((A1:A100)="c"), --((E1:E100)="w"))
For 'c' and 'l' use
=SUMPRODUCT(--((A1:A100)="c"), --((E1:E100)="l"))
For 'p' and 'w' use
=SUMPRODUCT(--((A1:A100)="p"), --((E1:E100)="w"))
For 'p' and 'l' use
=SUMPRODUCT(--((A1:A100)="c"), --((E1:E100)="l"))

HTH

"Warren1872" wrote:

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