Countif (and (problem

[jennyjsheffuk]

Hello
I'm wanting to count the number of instances of "Multi Worker" in column A1:A50 and identify how many belong to a specific team in column C1:C50 "GroupA" so my result would show that of the 50 enteries in column A only XX belong to GroupA.

Not sure if it's a countif or a sum product formula that I need.

Thanks in anticipation
Jenny

 

[njimack]

=SUMPRODUCT(--(A1:A50="Multi Worker"),--(C1:C50="GroupA))

 

[VoG]

Try

=SUMPRODUCT(--(A1:a50="Multi Worker"),--(C1:C50="GroupA"))

 

[jennyjsheffuk]

Hello
I've copied the formuls but my result is showing 0 when it should show 14 ???
Could someone kindly try this for me.
Thanks

 

[njimack]

Hello
I've copied the formuls but my result is showing 0 when it should show 14 ???
Could someone kindly try this for me.
Thanks

can you poste a sample of your data?

 

[jennyjsheffuk]

Column
A C

Multi Worker GroupA
Non Multi GroupC

Sorry it's as simple as that. I can't copie the data in a bit of a rush.

Thanks

 

[Matty]

If you have Excel 2007 or beyond, try:

=COUNTIFS(A2:A50,"Multi Worker",C2:C50,"GroupA")

Matty

 

[njimack]

Excel Workbook
	A	B	C	D	E
1	Multi Worker		GroupA
2	Non Multi		GroupC		1
Sheet1

 

[jennyjsheffuk]

Many thanks for your help.
Will try this out.
Regards
Jenny