ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1851
Location: Sydney, Australia
|
 Posted: Fri Mar 23, 2012 3:55 pm Post subject: |
 |
|
I think you need to use a helper row.
Assuming the absence of a zero is enough to indicate that all four names are present, then... | Code: | | =COUNTIF(A1:A4;0)=0 |
in A6 filled across to C6 will return TRUE, FALSE, TRUE in A6:C6.
Then this formula in A5 filled across to C5...
| Code: | | =IF(A6;SUM($A6:A6);0) |
will return 1, 0, 2 in A5:C5.
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
