Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Countif multiple worksheets | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
"countif" from multiple worksheets within workbook | Excel Discussion (Misc queries) |