View Single Post
  #2  
Old 18th August 2005, 11:47 AM
SeeDee SeeDee is offline
Member
 
Join Date: Apr 2005
Posts: 39
Default 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.
Reply With Quote