Countif headache

[Mattyads2011]

Hi.

I apologise if this is a really simple question but this has been bugging me for a while now so I am having to ask for some help please.

I am using Excel2003 the image below is only a part of my spreadsheet. I have tried to keep it to a minimum.

The below is on sheet1, on sheet 2 i am trying to break the data down in a number of ways, what I really need to do is show how many "AA" (Grade) have a review1 code of "hh"

Does anyone know how to do this? Countif statements do not seem to be working for me.

Appreciate any assistance.

<TABLE style="WIDTH: 488pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=652 border=0 x:str><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><COL style="WIDTH: 84pt; mso-width-source: userset; mso-width-alt: 4096" width=112><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" span=2 width=87><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3328" width=91><COL style="WIDTH: 84pt; mso-width-source: userset; mso-width-alt: 4096" width=112><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl28 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray 1pt solid; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; HEIGHT: 27pt; BACKGROUND-COLOR: #003366" width=87 height=36 rowSpan=2>Name</TD><TD class=xl26 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray 1pt solid; BORDER-LEFT: gray 1pt solid; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112 rowSpan=2>Department</TD><TD class=xl26 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray 1pt solid; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87 rowSpan=2>Grade</TD><TD class=xl26 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray 1pt solid; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87 rowSpan=2>TM</TD><TD class=xl26 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray 1pt solid; BORDER-LEFT: gray 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=76 rowSpan=2>CSM</TD><TD class=xl29 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray 1pt solid; BORDER-LEFT: gray 1pt solid; WIDTH: 68pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=91 rowSpan=2>Date</TD><TD class=xl28 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray 1pt solid; BORDER-LEFT: gray 1pt solid; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112 rowSpan=2>Review 1</TD></TR><TR style="HEIGHT: 13.5pt" height=18></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #003366" width=87 height=18>Test1</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>Inbound</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>AA</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>1test</TD><TD class=xl25 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 57pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=76>2test</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 68pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=91 x:num>140611</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>ll</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #003366" width=87 height=18>Test2</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>Inbound</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>AA</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>1test</TD><TD class=xl25 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 57pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=76>2test</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 68pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=91 x:num>140611</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>lm</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #003366" width=87 height=18>Test3</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>Inbound</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>CA</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>1test</TD><TD class=xl25 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 57pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=76>2test</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 68pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=91 x:num>140611</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>lh</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #003366" width=87 height=18>Test4</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>Inbound</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>CA</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>1test</TD><TD class=xl25 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 57pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=76>2test</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 68pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=91 x:num>140611</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>ml</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #003366" width=87 height=18>Test5</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>Inbound</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>CB</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>1test</TD><TD class=xl25 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 57pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=76>2test</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 68pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=91 x:num>140611</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>mm</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #003366" width=87 height=18>Test6</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>Outbound</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>CB</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>1test</TD><TD class=xl25 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 57pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=76>2test</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 68pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=91 x:num>140611</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>mh</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #003366" width=87 height=18>Test7</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>Outbound</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>AB</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>1test</TD><TD class=xl25 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 57pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=76>2test</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 68pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=91 x:num>140611</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>hl</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #003366" width=87 height=18>Test8</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>Outbound</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>AB</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>1test</TD><TD class=xl25 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 57pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=76>2test</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 68pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=91 x:num>140611</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>hm</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #003366" width=87 height=18>Test9</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>Outbound</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>AA</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>1test</TD><TD class=xl25 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 57pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=76>2test</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 68pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=91 x:num>140611</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>hh</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 1pt solid; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #003366" width=87 height=18>Test10</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>Outbound</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>CB</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 65pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=87>1test</TD><TD class=xl25 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 57pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=76>2test</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 68pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=91 x:num>140611</TD><TD class=xl24 style="BORDER-RIGHT: gray 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 84pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: #003366" width=112>hh</TD></TR></TBODY></TABLE>

 

[Domski]

Try: =SUMPRODUCT(--(C2:C11="AA"),--(G2:G11="hh"))

Dom

 

[barry houdini]

Hello Mattyads2011, welcome to MrExcel

Try SUMPRODUCT, something like this

=SUMPRODUCT((C2:C100="AA")*(G2:G100="hh"))

extend ranges as required - can't use the whole column

 

[VoG]

Try

=SUMPRODUCT(--(C2:C50="AAA"),--(G2:G50="hh"))

 

[Mattyads2011]

Thanks very much guys, worked a treat, never heard of SUMPRODUCT before.

I may have a question or two re userforms in the near future. Is it good practise to use the same thread or if it is a different subject to start a new one?

 

[VoG]

Please start a new thread for a new subject.