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.
Bookmarks