Max,
Thank you very much for the great reply. I've just set up the sheets as you
instructed, and it all looks very promising. I don't have the time right
now to experiment with it, but I should be able to do so within the next
couple days and will then let you know for sure how it works out.
I'm pretty sure I have correctly reconstructed your worksheets, but if the
offer is still open I'll take you up on the offer to send a sample book,
which you can send to rschwarz<atnetins<dotnet. Thanks again.
Bob
"Max" wrote in message
...
Put in R1: =COUNTIF($B$2:$Q$17,COLUMN(A1))
Copy across to S2
R1 gives the total of all the "1"s,
S2 gives the total of all the "2"s
Typos, sorry:
In the above, S2 should read as S1
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|