Posted to microsoft.public.excel.worksheet.functions

sarahlbdarling sarahlbdarling is offline

external usenet poster

Posts: 1

Conditional Formula, counting one criteria in a range based on ano

I have two columns of data, one being gender and the other being nationality.
I want to count how many British males there are, I can get the formulas to
work. I have tried many many variations of counta, countif, countifs, if etc
and none work.....where am I going wrong!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting dates based on certain criteria	steve_sr2[_2_]	Excel Worksheet Functions	5	March 1st 08 12:42 AM
Function - counting based on criteria	Candace	Excel Worksheet Functions	2	April 20th 06 07:41 PM
counting occurences based on two criteria	nackington	Excel Discussion (Misc queries)	6	April 20th 06 01:27 PM
conditional formula - based on 2 separate criteria	andrewo-s	Excel Worksheet Functions	10	March 14th 05 03:35 AM
counting based on criteria	SOT	Excel Worksheet Functions	0	March 9th 05 05:25 PM

All times are GMT +1. The time now is 06:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us