COUNTIF Not Working

[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

 

[Ron Rosenfeld]

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.


---

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