SUMIF / SUMPRODUCT Funtion

Just use filter. No need for a function. Select any cell in the gender column. On the home tab choose Sort & Filter, then filter. Click the button that shows up in C2 and make your choice.

Maybe this is what you are after.

I can create a user defined function, are you okay with that.

A user defined function means I write a function with code and then you use it just like you would Sum or Average, or any other function which means you type = the function name and then you have to enter certain arguments in a certain order and then hit enter and the function returns the results. I went ahead and built it anyway because according to this site I'm addicted to Excel, which I am, so I needed something to do.
If you like it and this is not the actual sheet you are going to use I will help you get it to the other sheet. The function is already installed and it seems to work well. It's called "FilterCount".
Good Luck!!!

Well you have many sources to learn VBA for yourself. There's a ton of videos on the internet and lots and lots of books.
I can give you a brief rundown of what it does.
Basically it takes your categories that we a looking to match and puts them into an array. It then takes the cells that we want to match and compares then one at a time to the categories. Looping is not the fastest way to do things in code, but my understanding is looping through and array is faster than looping through the cells. I also have code that looks at the 1 or 2 first and if that's not what we're looking for it skips all of those cells so that speeds it up and if a cell is empty it skips that cell also. So I've made it faster than if I had not ignored blank cells. To you and I it happens instantaneously so that's good.

Start here and decide if you like it.
http://youtu.be/AIhKNNXzZLM

Good Luck!!!

With D2 is 1 or 2 (men or women),try in D3 sheet Companies:

Please Login or Register  to view this content.