Previous Topic Next Topic

Comparing and analysing columns in EXCEL

Closed
Krpookie1 - Oct 27, 2009 at 09:25 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 30, 2009 at 01:49 AM
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!
Related:

1 response

Answer 1 / 1
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 30, 2009 at 01:49 AM
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Comparing columns and returning value
ll -
kittu -

35 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses