anther countif condition problem

[xtrmhyper]

problem

A---------B--------- C--------D------
1
2 ACS ACTIVE DISCON
3 ACS ACTIVE INSTALL
4 ACS ACTIVE RECON
5 ACS ACTIVE INSTALL
6 ACS ACTIVE INSTALL

I HAVE A DROP-DOWN IN COLUMN D1(DISCON,INSTALL,RECON,SUMMARY)
IF I CHOOSE DISCON TOTAL=1 IF INSTALL=3 IF RECON=1
MY PROBLEM IS, IF I CHOOSE SUMMARY IN DROPDOWN I WANT
ADD ALL RECON,INSTALL AND DISCON TOTAL IS 5

TNX
IN ADVANCE:

 

[Biff]

Hi!

Try this:

=IF(D1="","",IF(D1="Summary",COUNTIF(C2:C6,"*"),COUNTIF(C2:C6,D1)))

Biff