| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT and SUM
Hi, can you count and sum at the same time? I want to count how many boys
('m' in column B) have a test score (1+ in column O) then total how much progress they have made since the last test (column P). I would also like to count how many more able children (any text in column E) have a test score (in column O) and then total their progress since the last test (column P). My column O returns a #N/A value if no score is entered. Thanks Mrs T |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
![Mrs T.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
