If function

[Paul]

Hi,

Newbie question...I have two teams (America and
Europe)...I just want to count how many projects from
America will go to QA-LA (in this example, that would be
3)...Need help! What would be the formula ?

(A) (B) (C)
(1) Team Status Target date QA-LA

(2) America CR
(3) America QA-MTL 2004-03-23
(4) America Deployment 2004-03-26
(5) America Deployment 2004-03-26
(6) America QA-LA#1
(7) America On Hold
(8) Europe QA-LA#1
(9) Europe On Hold
(10)Europe

 

[Frank Kabel]

Hi Paul
do you determine whether a project goes to QA-LA or not if column C is
filled or empty? If yes try
=SUMPRODUCT((A1:A100="America")*(C1:C100<>""))