Counting
 

Can anyone tell me whether there is a way to count up the number of cells in
a column that contain a specific word but only if there is a specific word in
another column e.g.

Column A Column B
1 Elective Yes
2 Elective No
3 Urgent No
4 Urgent Yes
5 Urgent Yes

I would like excel to tell me how many "urgent" in column A where "yes" is
present in column B i.e. the answer in above example would be 2.

Hope this makes sense!

John

Counting
 

Try...

=SUMPRODUCT(--($A$1:$A$5="Urgent"),--($B$1:$B$5="Yes"))

Hope this helps!

In article ,
JRD wrote:

Can anyone tell me whether there is a way to count up the number of cells in
a column that contain a specific word but only if there is a specific word in
another column e.g.

Column A Column B
1 Elective Yes
2 Elective No
3 Urgent No
4 Urgent Yes
5 Urgent Yes

I would like excel to tell me how many "urgent" in column A where "yes" is
present in column B i.e. the answer in above example would be 2.

Hope this makes sense!

John

Counting
 

=SUMPRODUCT(--(A2:A50="Urgent"),--(B2:B50="Yes"))

replace the criteria with cell references for better usability and just put
the criteria in the cells


--


Regards,


Peo Sjoblom


"JRD" wrote in message
...
Can anyone tell me whether there is a way to count up the number of cells
in
a column that contain a specific word but only if there is a specific word
in
another column e.g.

Column A Column B
1 Elective Yes
2 Elective No
3 Urgent No
4 Urgent Yes
5 Urgent Yes

I would like excel to tell me how many "urgent" in column A where "yes" is
present in column B i.e. the answer in above example would be 2.

Hope this makes sense!

John

Counting
 

=SUMPRODUCT(--(A1:A5="Urgent"),--(B1:B5="Yes"))
--
Gary''s Student - gsnu200754


"JRD" wrote:

Can anyone tell me whether there is a way to count up the number of cells in
a column that contain a specific word but only if there is a specific word in
another column e.g.

Column A Column B
1 Elective Yes
2 Elective No
3 Urgent No
4 Urgent Yes
5 Urgent Yes

I would like excel to tell me how many "urgent" in column A where "yes" is
present in column B i.e. the answer in above example would be 2.

Hope this makes sense!

John

Counting
 

This should do it for you:
=SUMPRODUCT(--(A1:A5="Urgent"),--(B1:B5="Yes"))

Regards,
Ryan---


--
RyGuy


"JRD" wrote:

Can anyone tell me whether there is a way to count up the number of cells in
a column that contain a specific word but only if there is a specific word in
another column e.g.

Column A Column B
1 Elective Yes
2 Elective No
3 Urgent No
4 Urgent Yes
5 Urgent Yes

I would like excel to tell me how many "urgent" in column A where "yes" is
present in column B i.e. the answer in above example would be 2.

Hope this makes sense!

John