Comparing and analysing columns in EXCEL [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,
Can anyone help me?

I want to create a formula to analyse 2 or more columns in excel.
For example I have a column headed 'gender' and another headed 'level'. I've inputted the data but want to be able to create a formula that can tell me for example how many boys got a level 1. Can this be done - Im fairly confident with excel but just cannot seem to find a solution to this and it would save me hours of time if I could find one.

Any help would be grately apprecaited!

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello There,

Use this formula =SUM((D7:D12="m")*(E7:E12=1))
where D7:D12 is the range where you have the data:gender
"m" denotes the text you mentioned (male/M/?)
E7:E12 is the range where you have the data:level
1 denotes the level

ENTER THE FORMULA BY PRESSING CTRL +SHIFT+ENTER