=SUMPRODUCT(--(Format(INDIRECT("'"&$A2&"'!A2:A366"),"mmm")=$B2), OFFSET(INDIRECT("'"&$A2&"'!B2:Y366"),0,COLUMN(A1)-1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ray" wrote in message
ups.com...
Bob,

The Summary sheet uses Months (format:MMM) , while the source sheets
use days (format: MM/DD/YY) -- how would I modify your suggested
formula to make this conversion?

thanks, ray