Guys,

I need some help again.

I need to do a countif by two functions. The formula i have entered and tried is;

=COUNTIF($F$2:$F$110,AND($H$2:$H$110<(NOW()-183),F113))

Column F has codes in it, so for example G1, G2 etc
Column H has a date that it was raised on.

So what I am trying to do is count the column F range by the following two criteria:

The date in column H being less then 6 months and then the code (F113 would contain G1 as a table legend at the bottom.)

Thanks Guys