Quote Originally Posted by windme
Hello,

Using Excel 2007

In the following example I want to count the number of times a "4" shows up but just for the cells A1:D1 and A3:D3 (non adjacent cells). When I write the formula =countif(A1:D1,A3:D3,4) I receive an error.
See attached sample.

How can I write a countif formula for non adjacent cells?
Any help would be appreciated.

Michael
Simplest way would be to just add another countif. i.e.
=COUNTIF(A1:D1,4)+COUNTIF(A3:D3,4)
Rgds