
18th August 2005, 11:47 AM
|
Member
|
|
Join Date: Apr 2005
Posts: 39
|
|
Twodogs
There's probably a better way, but I would add a field at the bottom of each column with a flag identifying if the column has 1, 2 or 3 in it. Then simply total the row. For instance A26 would contain "=if(countif(A1:A24,"<4"),1,0)". Copy this thru remaining 7 columns (B:H)
The 9th column (say I26) would contain a field with "=SUM(A26:H26)"
I am sure there is a more elegant method but this will work.
Good luck.
|