I have a spreadsheet of students grades across different subjects with
formula rows below to total grades by subject, then convert totals to
percentages. I need to do the same analysis for male and female students
separately, then produce a summary in a separate worksheet. Is there a way
to do this using an IF formula to keep the three analyses (All, F, M) on the
same sheet, so that I can then create links to show the summary on a
different sheet?

Suppose you have M or F in column B, with column C used for the first
subject. Suppose you have 100 rows of data, then you can put this
formula below your data (eg in cell C102):

=SUMIF($B$1:$B$100,"M",C$1:C$100)

to give the total marks for males, and in C103:

=SUMIF($B$1:$B$100,"F",C$1:C$100)

will give the total marks for females. Copy these two formulae across
the row for as many subjects as you have.

Hope this helps.

Pete

On Sep 16, 9:44*am, JVS wrote:
I have a spreadsheet of students grades across different subjects with
formula rows below to total grades by subject, then convert totals to
percentages. *I need to do the same analysis for male and female students
separately, then produce a summary in a separate worksheet. *Is there a way
to do this using an IF formula to keep the three analyses (All, F, M) on the
same sheet, so that I can then create links to show the summary on a
different sheet? *