i'm tired :(
please help.
i have a list of hospital accounts with codes for seven hospitals.
i need a summary sheet to count a range of codes for each hospital.
i'm using:
=SUMPRODUCT(--('Jan
08'!A7:A150="1"),--(G7:G150=--"707"),--(G7:G150<=--"707.9"))

1=hospital number 1
the codes are a range from 707 to 707.9

i can get it to look for one single number, but not a range. :(


i get the first part to work



--
terri