Hello,

I have serval spreadsheets in one book. I need to
calculate a total for a particular cell on each
spreadsheet if a different cell on the same spreadsheet
meets certain criteria.

For example, I want to take the Price cell (D5, for
example) for each salesperson on all spreadsheets where
the Manager Name of the salesperson is "Bob" (cell A2 for
example) and place that total number in the cell of a new
spreasheet within the same book. So I want to total all
of the D5 cells on each spreadsheet where A2 = Bob and
link that total to the F5 cell of a new spreadsheet. The
tabs in the book are salespeople's names listed
alphabetically.

I hope how I've explained this makes sense!

Thanks for your help!!!
Di