COUNT and SUM
"Mrs T." wrote:
"Mrs T." wrote in message
...
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
|