Hi Marielle

One way
=SUMPRODUCT(--(A1:A30="V"),--(F1:F30="A"))

--
Regards

Roger Govier


"Marielle" wrote in message
...
I want to create a countif formula containing two areas and conditions,
i.e.
=countif(A1:A30;"V1") AND (F1:F30;"A"). How do I write the formula to
make
it work? Please help...