Using counta function for 2 columns.

[Steve-B]

Hi all,

I'm using the following COUNTA function for a range of cells.

=COUNTA(W92:W580)

In column X92:W58 i have a drop down list to pick a gender, (Male , Female). Can I add to the counta function so that I can count all data entered into W92:W580 and get it filtered by gender.

E,g Say there were 10 data entires within the counta range and 3 were female my table would show: Male: 7 Female: 3 Total:10?

Thanks in advance.

[EdMac]

have you thought of using sumproduct?

Check out this site

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Regards

[Steve-B]

Thanks Ed,

Yeah I've used SUMPRODUCT yet could'nt think of linking the 2 functions. Basically users will enter a date and thats what will be counted.

Thanks for the link.

[EdMac]

Can you post an example of your data and what you want to achieve? Best to ZIP it first.

Regards