Help with countif on multiple worksheets

[jeremed]

First off, I'd like to thank everyone who's posted solutions on thi
forum. I've found help with 95 percent of my issues through the search
I have this one last problem that I haven't been able to nip.

I have 6 worksheets. I have 52 rows that contain names and a colum
which contains numbers. I need to tally the total for each cell with
number in all six worksheets and show the name from the row AND th
number from the totalled columns if they're greater than a certai
other number.

I made a simple layout of how my worksheets look. Each one looks lik
this and has the same format.


name 32
name 23
name 25
name 25
name 23

Any help will be greatly appreciated

 

[Earl Kiosterud]

jeremed,

Presumably, a given name isn't in the same row in the various sheets, so the
formula has to find it. A messy combination of SUM and six VLOOKUP
functions could do this. You'd have to make 52 of them. It's generally
better to keep similar data in one sheet, using an additional column to
differentiate them (instead of separate sheets). Take a look at "Data
across multiple sheets" at http://www.smokeylake.com/excel/excel_truths.htm

 

[jeremed]

The same names are actually in each place on the worksheets. I read you
article. I will retool my sheet, but later. Thanks for your help