I am trying to figure out how to do a sheet summary.
What I am trying to do is figure out the fomula to;
check column i23..i900 if it = "m" then check column L23..L900 if it equals "midget" then add 1
this is what I have now;
@countif(L23..L900,"=midget") which works counting only column L, currently have the same fomula for each seperate value in column L, but I want to know out of each Midget value how many are male and how many are female which is contained in column i
now how do I get it to take into consideration what the value is in column r before adding the value in I?
Column i only has values of "M" or "F"
Column L has values of "Midget", "Bantam" etc.....
What I am trying to do is figure out the fomula to;
check column i23..i900 if it = "m" then check column L23..L900 if it equals "midget" then add 1
this is what I have now;
@countif(L23..L900,"=midget") which works counting only column L, currently have the same fomula for each seperate value in column L, but I want to know out of each Midget value how many are male and how many are female which is contained in column i
now how do I get it to take into consideration what the value is in column r before adding the value in I?
Column i only has values of "M" or "F"
Column L has values of "Midget", "Bantam" etc.....