Find solution
Where did formula 1 get its name from?

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...!!!

  • Answer:

    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.

Moonzy at Answerbag.com Visit the source

Was this solution helpful to you?

Other answers

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

Annaick

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.

SpreadsheetsDirect

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.