I have entered different students name in column A, Paper name in Column B & their marks in column C. i've applied this formula:
if(A2:A66000="John Marks",sum(C2:C66000))
to get the total marks of John in all papers,but it doesnt work. plz help...!!!
by 
Moonzy
ANSWERS: 3
-
The easiest way would be to re-arrange the way you enter your data. I suggest using the names of the papers as column headings (eg Geography, Maths, English, French, History) this would save a lot of typing because you would only have to enter each student name and paper name once. You would then only need to sum the contents of the row to get each students total. Arranging the data this way would also make it much easier to analyse overall performance in individual subjects.
-
try =SUMIF(A2:A66000,"John",C2:C66000). Although if you have a lot of students you might be better of using a pivot table to give you a summary. If you're not using 2007, select all the data, click Data - Pivot Table Report. Click Next twice til you get to Step 3. Drag the Student name field into Row and Marks field into Data, if it's not showing as sum of then double click it to change. Finish and you should get a table with all student names and total marks next to them.
-
please try something like this: =sumif(A:A,"John Marks",C:C) or =sumif(A2:An,"John Marks",C2:Cn) ("n" for the max number of cells per column) do you really have 66000 different cells per column? O_o it may work if you also reduce this number...
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC