See example http://cjoint.com/?citAACtV8t

=SUMPRODUCT(SUMIF(INDIRECT("Feuil"&ROW(1:4)&"!A2:A 6"),$A$2,INDIRECT
("Feuil"&ROW(1:4)&"!B2:B6")))

JB
http://boisgontierjacques.free.fr

On 6 fév, 17:54, Brandon wrote:
Can it be done for 5 or more spreadsheets? *Just trying to figure out if
there is a way I can get it to look it up across the board so I don't have to
make an Access Database.

Thanks,
Brandon