Excel Problem 4

[RAClarke]

I have an Excel spreadsheet that needs to count the number of x's in column 1. However the totals depend on the gender of the client - what sort of formula could do this?

Name Gender 1
----------------------------
Dominic M X
Rebecca F X
Richard M
Jade F X

Total Males 1
Total Females 2

 

[Dreamboat]

=SUM((A2:A5="m&quot*(B2:B5="x&quot)

This formula will work but must be entered as an array formula. To do that, you type the formula in and while still INSIDE the cell, hit Ctrl-Shift-Enter (instead of the usual Enter). Your formula will then look like this:

{=SUM((A2:A5="m&quot*(B2:B5="x&quot)}

Do not type the curly brackets. They appear because you hit Ctrl-Shift-Enter.


techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[pjm]

Dreamboat,

That is just so neat that it deserves a star!

pjm

 

[bherring87]

That is really neat, but why does it work?

I also give you a star.

 

[Dreamboat]

Why does it work? Hmmm...

For the same reason everything at

http://www.cpearson.com/excel/topic.htm

and

http://www.erlandsendata.no/english/index.htm

work?

Dunno! LOL LOL LOL
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[marchristensen]

Dreamboat
I sent a star too as both these web sites look extremely useful. Thanks for sharing your magic.

 

[Dreamboat]

Terrific sites, yes? I love them!
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word