Sumproduct on multiple sheets...please help???
I checked all the dates, and are June dates, formatted correctly. Then I
filtered for just his name and checked for spacing....is ok. I did notice
that his name was the first one on the list for June 2nd, maybe ironic? but
wondering if it's got something to do with only his not showing up?
"Pete_UK" wrote:
Or, indeed, perhaps one or more of the dates for that doctor is
outside the range of the dates on the summary sheet - perhaps it was
typed in as March (03), when it should have been May (05).
Pete
|