Urgent help me with a Excel formula please!!

philstanbridge

philstanbridge

philstanbridge

Man of Honour
Joined
18 Oct 2002
Posts
8,522
Location
West Coast of Scotland
Can some kind soul give me some Excel advice please I am desperate. I have to finish my assignment tonight and for some reason I cannot work out what the formula is I need to use.

All I need is this. To count how many "Married" in one column, "servants" in another and add them together. I cannot work it out and I'm pulling my hair out with frustration!!
 
whitecrook said:
count(a1:a26,"married") or something like that
Click to expand...

That's correct so far as one goes, but how do I get it to add the other? Sorry its not just adding it, I need to select from a table of over 4000 entries which servants were married from this list. But there are servants who are unmarried for example.
 
erm, yes I think so. This data is 10mb in size and it's a pain. It's statistical analysis and I need to find how many servants were married. Sounds simple but I'm not finding it so.
 
JC said:
Is your data in a text format with columns that say "married" and "servant"
Or is the data under a heading Married and Servant with 1 or 0 as the output?
Click to expand...

It's text format but not straightforward. Columns say OCCUPATION, CIVIL STATUS etc. I was under the impression I need to use COUNTIF, although it may be COUNTIFS. God knows.
 
ahhhaha! I've sorted it, but not in Excel! How bizarre. I had to use star office in the end to work it out. But thanks for your help guys! (I'm still curious mind you, love to know what the formula is in Excel). I've been on this assignment all week, and today since 9am!
 
You must log in or register to reply here.
Back
Top Bottom