Hi

Can anyone assist with a multiple COUNTIF formula. I basically want to
count two values in a range of cells. At the moment Im putting in entering
something like -
=COUNTIF(C:C,"XXXX") AND COUNTIF(C:C,"YYYY").
However, this is not working so Im assuming I should be using a command
other than 'AND' to link them.

Any help advice appreciate. Thanks in advance!