One way:
=SUMPRODUCT(--(C1:C1000="1-Critical"),--(E1:E1000="CW App Issue"))
for an explanation of the "--", see
http://www.mcgimpsey.com/excel/doubleneg.html
In article ,
mcdc01 wrote:
Hello,
I would like to be able to return a variety of metrics for a range of cells
that text and numbers. In the first example, I would like to be able to
return the total number of records where the value €śDev_Assigned€ť is in
Column B, the value €ś1-Critical€ť is in Column C and the number in Column D is
greater than one but less than 4:
Column A Column B Column C Column D Column E
WUP00020460 Dev_Assigned 1-Critical 2 CW App Issue
WUP00020596 Dev_Assigned 1-Critical 2 CW Env Issue
WUP00020731 Test 1-Critical 1 CW Env Issue
WUP00020465 Dev_Assigned 2-High 2 CW Env Issue
WUP00020461 Test 3-Medium 2 CW Data Issue
WUP00020592 Open 2-High 2 CW User Issue
WUP00020733 Dev_Assigned 1-Critical 4 CW Data Issue
WUP00020464 Test 2-High 2 CW Data Issue
WUP00020465 Dev_Assigned 1-Critical 5 CW App Issue
WUP00020597 Dev_Assigned 1-Critical 3 CW Env Issue
WUP00020738 Test 1-Critical 1 CW Test Issue
WUP00020469 Dev_Assigned 2-High 2 CW Env Issue
In the second example, using the data above, I would like to be able to
return the total number of records where the value €ś1-Critical€ť is in Column
C and the value €śCW App Issue€ť is in Column E.
Any help or guidance is greatly appreciated!