finding total from 2 seperate columns

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I need to have total from 2 columns. If the person is male and is 198 = 2, if
person is male and 123 = 1. if person is F and 275 = 0. I have tried countif
and sum but must be to dumb to get it. PLEASE HELP!!!!!

M 220
M 181
M 198
M 123
F 97
M 132
M 198
M 148
F 123
F 148
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data only if adjacent to cell labeled "male"/"female" 1
MIN and MAX across columns 6
countif, sumif, or whatever - counitg just some psecific values 2
Return a value based on 2 or more columns of information 2
countif OR function 5
Complex function needed? 5
% error calculating grades 4
COUNT and SUM (please help!) 11

Back
Top