Complex count formula
 

How do I count values from different fields if they meet certain criteria?
Here is a sample formula:
=COUNT(IF(('Defect Log'!$D$2:$D$1377="Severity 3 (Med/Low)")*('Defect
Log'!$F$2:$F$1377="20 In Analysis"),1))+(IF(('Defect
Log'!$D$2:$D$1377="Severity 3 (Med/Low)")*('Defect Log'!$F$2:$F$1377="10
New"),1))+(IF(('Defect Log'!$D$2:$D$1377="Severity 3 (Med/Low)")*('Defect
Log'!$F$2:$F$1377="30 Resolution In Progress"),1))+(IF(('Defect
Log'!$D$2:$D$1377="Severity 3 (Med/Low)")*('Defect Log'!$F$2:$F$1377="45 Hot
Fix Delivered"),1))

It counts 20 In Analysis and 10 New but after that it stops. Any suggestions
would be greatly appreciated.
Thanks

Complex count formula
 

=SUMPRODUCT(('Defect Log'!$D$2:$D$1377="Severity 3
(Med/Low)")*(('Defect Log'!$F$2:$F$1377="20 In Analysis")+('Defect
Log'!$F$2:$F$1377="10 New")+('Defect Log'!$F$2:$F$1377="30 Resolution
In Progress")+('Defect Log'!$F$2:$F$1377="45 Hot Fix Delivered")0))

HTH
Kostis Vezerides


Wmcculler wrote:
How do I count values from different fields if they meet certain criteria?
Here is a sample formula:
=COUNT(IF(('Defect Log'!$D$2:$D$1377="Severity 3 (Med/Low)")*('Defect
Log'!$F$2:$F$1377="20 In Analysis"),1))+(IF(('Defect
Log'!$D$2:$D$1377="Severity 3 (Med/Low)")*('Defect Log'!$F$2:$F$1377="10
New"),1))+(IF(('Defect Log'!$D$2:$D$1377="Severity 3 (Med/Low)")*('Defect
Log'!$F$2:$F$1377="30 Resolution In Progress"),1))+(IF(('Defect
Log'!$D$2:$D$1377="Severity 3 (Med/Low)")*('Defect Log'!$F$2:$F$1377="45 Hot
Fix Delivered"),1))

It counts 20 In Analysis and 10 New but after that it stops. Any suggestions
would be greatly appreciated.
Thanks