Countif - No Adjacent Cells

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

Thanks for your reply.

What could I use if had like 50 or more different non adjacent cells? Is there a sorter, "simpler" formula?
Thanks.