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? |
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 |