Help with countif on multiple worksheets
 

First off, I'd like to thank everyone who's posted solutions on this
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 column
which contains numbers. I need to tally the total for each cell with a
number in all six worksheets and show the name from the row AND the
number from the totalled columns if they're greater than a certain
other number.

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


name 32
name 23
name 25
name 25
name 23

Any help will be greatly appreciated.


--
jeremed
------------------------------------------------------------------------
jeremed's Profile: http://www.excelforum.com/member.php...o&userid=24982
View this thread: http://www.excelforum.com/showthread...hreadid=385155

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
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"jeremed" wrote in
message ...

First off, I'd like to thank everyone who's posted solutions on this
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 column
which contains numbers. I need to tally the total for each cell with a
number in all six worksheets and show the name from the row AND the
number from the totalled columns if they're greater than a certain
other number.

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


name 32
name 23
name 25
name 25
name 23

Any help will be greatly appreciated.


--
jeremed
------------------------------------------------------------------------
jeremed's Profile:
http://www.excelforum.com/member.php...o&userid=24982
View this thread: http://www.excelforum.com/showthread...hreadid=385155

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


--
jeremed
------------------------------------------------------------------------
jeremed's Profile: http://www.excelforum.com/member.php...o&userid=24982
View this thread: http://www.excelforum.com/showthread...hreadid=385155