AAAARrrrrrrrrrrrrrrrrgggggggggggggghhhhhhhhhhhh Formulas

[sarahlbdarling]

I have a worksheet of information I am trying to analyse using formulas. I am
able to count the number of specific occurances of a word eg British but I
cannot link this count formula to condition the result from another column to
give a count of British females!

It is driving me mad as I have now gone through every help file and tried
everything!

The data is in columns, column A = gender, Column B = nationality, rows 2
-270.

all help gratfully appreciated

[SamuelT]

Hi,

One option is, in another column enter the following formula:

=IF(AND(A1="Female",B1="British"),True,False)

Then (and let's say we put the above formula in C), put the following wherever you're displaying your British Females (ooh-er!!):

=COUNTIF(C1:270, True)

That should do it.

SamuelT

[CLR]

=SUMPRODUCT(--(A2:A270="British"),--(B2:B270="female"))

Vaya on Dios,

Chuck, CABGx3



"sarahlbdarling" wrote:

> I have a worksheet of information I am trying to analyse using formulas. I am
> able to count the number of specific occurances of a word eg British but I
> cannot link this count formula to condition the result from another column to
> give a count of British females!
>
> It is driving me mad as I have now gone through every help file and tried
> everything!
>
> The data is in columns, column A = gender, Column B = nationality, rows 2
> -270.
>
> all help gratfully appreciated
>

[sarahlbdarling]

Thanks Samuel,

Only slight problem with your suggestion is that we have 270 rows of data,
either male or female which is fine but there are then 43 different
nationalities so would not really solve the problem and we would end up with
pages of true/false columns!

thanks though!

"SamuelT" wrote:

>
> Hi,
>
> One option is, in another column enter the following formula:
>
> =IF(AND(A1="Female",B1="British"),True,False)
>
> Then (and let's say we put the above formula in C:
>
> =COUNTIF(C1:270, True)
>
> That should do it.
>
> SamuelT
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=552608
>
>

[Bernie Deitrick]

Sarah,

The simple answer is: Don't use formulas.

Use a Pivot table - look in help for more.

HTH,
Bernie
MS Excel MVP

"sarahlbdarling" <[email protected]> wrote in message
news:[email protected]...
>I have a worksheet of information I am trying to analyse using formulas. I
>am
> able to count the number of specific occurances of a word eg British but I
> cannot link this count formula to condition the result from another column
> to
> give a count of British females!
>
> It is driving me mad as I have now gone through every help file and tried
> everything!
>
> The data is in columns, column A = gender, Column B = nationality, rows 2
> -270.
>
> all help gratfully appreciated
>