Counting names across multiple spread sheets (sort of)

[Toppyoushimo]

Here's my issue, I need to count specific names across lots of spread sheets (all the sheets in between sheets 'First:Last'), and also how much they have paid. My issue is that the names are not always in the same row throughout the spreadsheets. The amount that they have paid is always in the same row as the name and always in column I. I need a formula that will find the name and count the paid column (column I). If there is such a formula. Thanks for your time and effort.

[Tony Valko]

Sounds like you want to do a SUMIF across the sheets.

Let's assume the names are in column A.

Make a list of the sheet names in a range of cells. Let's assume that list is in the range A1:A10.

C1 = some name

Then, this formula:

=SUMPRODUCT(SUMIF(INDIRECT("'"&A1:A10&"'!A:A"),C1,INDIRECT("'"&A1:A10&"'!I:I")))