The syntax for COUNTIF is =COUNTIF(range, criteria)
So there are just two arguments while you have 3

Did you mean to use SUMIF?
The syntax is =SUMIF(range, criteria, [sum_range]) where sum_range is
optional
So to sum the second range when the first range has the same value as AN11
you would need
=SUMIF($F11:$AN11, AN11, $AR11:$BF11)
However, the first range F:AN includes 35 cells while the second has only 15
so you will get an error message.

Please tell us more about the problem
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Gotroots" wrote in message
...
Hi

Could someone be kind enough to tell me what is wrong with the following
formula

=COUNTIF($F11:$AN11,$AR11:$BF11,AN11)=1

Thaks