Hi

A bit too little info about your setup, but I'll try to help anyway.

Let's assume you have data in range A2:F100 on sheet Table. In column C is
info about sex, p.e. "M" or "F". In column E is info about Asperges
(whatever it may be!) - TRUE or FALSE. Then the formula to count all males
with Asperges will be:
=SUMPRODUCT(--(Table!$C$2:$C$100="M"),--(Table!$E$2:$E$100=TRUE))

(Edit the formula to adjust it to your worksheet setup)

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"mrayner" wrote in
message ...

Hi Guys,

Can someone please help me out with this problem.
In the spreadsheet there are 2 main colums I need to count.
I have a set of results tables on the right that are lacking results
:)

So in Q5 I need a function that checks that the subject is a male, and
they have Aspergers... count 1, then goto the next row and keep
counting down the entire spreadsheet. Then in S5, obviously count all
the females with Aspergers etc. etc.....

I know it is probably easy and I should learn myself but if someone can
tell me the first function or 2 that'd be fantastic. I just don't have
time to learn anything more than I allready know about Excel at the
moment.

I promise I will learn and hoepfully help other people on this forum in
the future...

I have attached a renamed, waaayyy cut down version to with post.
((((I renamed the file to doc just so i could attach it to this post,
you will have to rename it..))))

Thanks!

- Mark


+-------------------------------------------------------------------+
|Filename: Simple Ver.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3540 |
+-------------------------------------------------------------------+

--
mrayner
------------------------------------------------------------------------
mrayner's Profile:
http://www.excelforum.com/member.php...o&userid=24656
View this thread: http://www.excelforum.com/showthread...hreadid=382382