Help with countif on multiple worksheets

[jeremed]

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.

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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]

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.

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"jeremed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>