| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Should I use COUNT IF? from one sheet to another
I want to count the totals of various text strings together from sheet 2 eg on sheet 2 , I want to know the total of Jack, John, Mary & Kates scores as a whole (each appear atleast 10 times in the different rows) There are hundreds of rows with different names but need the totals of these particular 4. The names are are in column D and the totals in column H I need to show the answer in sheet 1 Please can anybody help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Should I use COUNT IF? from one sheet to another
Hi Amanda,
you can use sumproduct to do it, =sumproduct(--(sheet1!d2:d100="Jack");(h2:h100))+sumproduct(--(sheet1!d2:d100="John");(h2:h100))+sumproduct(--(sheet1!d2:d100="mary");(h2:h100))+sumproduct(--(sheet1!d2:d100="kate");(h2:h100)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Amanda" escreveu: I want to count the totals of various text strings together from sheet 2 eg on sheet 2 , I want to know the total of Jack, John, Mary & Kates scores as a whole (each appear atleast 10 times in the different rows) There are hundreds of rows with different names but need the totals of these particular 4. The names are are in column D and the totals in column H I need to show the answer in sheet 1 Please can anybody help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Should I use COUNT IF? from one sheet to another
Thanks Marcelo
All working perfect! "Marcelo" wrote: Hi Amanda, you can use sumproduct to do it, =sumproduct(--(sheet1!d2:d100="Jack");(h2:h100))+sumproduct(--(sheet1!d2:d100="John");(h2:h100))+sumproduct(--(sheet1!d2:d100="mary");(h2:h100))+sumproduct(--(sheet1!d2:d100="kate");(h2:h100)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Amanda" escreveu: I want to count the totals of various text strings together from sheet 2 eg on sheet 2 , I want to know the total of Jack, John, Mary & Kates scores as a whole (each appear atleast 10 times in the different rows) There are hundreds of rows with different names but need the totals of these particular 4. The names are are in column D and the totals in column H I need to show the answer in sheet 1 Please can anybody help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want cell ref. to change after sort in other sheet | Excel Discussion (Misc queries) | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
