counting rows wen 2 arguments are true

[SoulReaper]

is there any way i can create a formula to count the amount of rows when
2 arguments are true?

i have two columns with text in them, say A1:A10 and B1:B10 id like to
find a way of counting the rows when both ranges have specific text in
them. eg

ACCOUNT TYPE[/B] FULLTIME/PARTIME

ordinary Fulltime
ordinary Partime
ordinary Fulltime
ordinary Fulltime
ordinary Fulltime
student Fulltime


say i wanted to count the rows wen account type = ordinary and
fulltime/partime = Fulltime. is this at all possible any help would be
appreciated.

 

[A.W.J. Ales]

SoulReaper,

=SUMPRODUCT((A1:A10="ordinary")*(B1:B10="Fulltime"))

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[wie.niet]

is there any way i can create a formula to count the amount of rows when
2 arguments are true?

i have two columns with text in them, say A1:A10 and B1:B10 id like to
find a way of counting the rows when both ranges have specific text in
them. eg

ACCOUNT TYPE[/B] FULLTIME/PARTIME

ordinary Fulltime
ordinary Partime
ordinary Fulltime
ordinary Fulltime
ordinary Fulltime
student Fulltime


say i wanted to count the rows wen account type = ordinary and
fulltime/partime = Fulltime. is this at all possible any help would be
appreciated.

you could enter a new column with the formula
=IF(AND(A1="ordinary";B1="Fulltime));1;0)
and than summarize this column

 

[SoulReaper]

k thanks guys got it working