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