KarinaSilich
New Member
- Joined
- Sep 10, 2014
- Messages
- 8
Hi Everyone. I am new here so I hope I am doing the correct thing. I was wondering if someone could please help me with a problem I am having with my spread sheet for work? I will try and explain this as best I can so please stay with me OK I have column A and Column B. Column A has the sex of my employees and Column B has their ages. I require a formula that will add all the male's in column A plus wether they are >17 but <24. I thought the following formula's might work but the first is coming back as 0 and the second is saying #VALUE!...the first formula is =COUNTIFS(K2:L84,"Male",K2:L84,">17",K2:L84,"<24") or the second formula is =DCOUNTA(K2:L84,">17 <25","Male"). I kinda need the information to automatically populate when a new starter starts so my statics are correct but I am getting completely lost and very frustrated. Am I asking to much of Excel? Is it even possible? your help is very much appreciated everyone Karina