In Sheet2, the dynamic results should appear in col B.
(Col A is the criteria, hide it away, as mentioned)
Give it another try. I tested it fine over here. It dhould work over there.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"golddave via OfficeKB.com" <u54833@uwe wrote in message
news:9c407414dac3b@uwe...
I'm getting what appear to be random numbers from these formulas.