COUNTIF Not Working

  • Thread starter Thread starter bapple100
  • Start date Start date
B

bapple100

Can someone please offer some help

A B C D E
1 SPR NFR Week Priority Complete
2 1968 1 1 Y
3 9874 1 1 Y
4 1971 2 2 N
5 1972 1 1 Y
6 9562 3 1 N
7 9745 2 1 N
8 1976 3 3 N

Above are the rows and columns as my example

Goa - I want to know what SPR's (column A) have a 1 in the Week(C
column and also have a 1 in the Priority (D) column

The result should be at total of 2 - SPR's 1968 and 1972 both have a
in the Week (C) column and a 1 in the Priority (D) column.

Any help would be greatly appreciated
 
Can someone please offer some help

A B C D E
1 SPR NFR Week Priority Complete
2 1968 1 1 Y
3 9874 1 1 Y
4 1971 2 2 N
5 1972 1 1 Y
6 9562 3 1 N
7 9745 2 1 N
8 1976 3 3 N

Above are the rows and columns as my example

Goa - I want to know what SPR's (column A) have a 1 in the Week(C)
column and also have a 1 in the Priority (D) column

The result should be at total of 2 - SPR's 1968 and 1972 both have a 1
in the Week (C) column and a 1 in the Priority (D) column.

Any help would be greatly appreciated.


---
Click to expand...

You may want to use SUMPRODUCT. Something like

=SUMPRODUCT((Priority=1)*(Week=1))

It's hard to tell exactly what you want.

In your post, the columns may not be properly lined up. Under Priority I see
only Y or N. If I shift things over, then there are three SPR's that have 1's
in two columns (1968, 9874, 1972).

If you want to "know what SPR's have ..." then describe how you want to
identify them. You could use conditional formatting to highlight the
appropriate rows.


--ron
 
Back
Top