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.Originally Posted by windme
Rgds
Please Login or Register to view this content.
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.
Try this:
=SUM(COUNTIF(INDIRECT({"A1:D1","A3:D3"}),4))
IF you count every odd rows then try this:
=SUMPRODUCT((MOD(ROW(A1:D100),2)=1)*(A1:D100=4))
Last edited by Teethless mama; 02-17-2008 at 03:05 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks