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
Bookmarks