counting rows wen 2 arguments are true

  • Thread starter Thread starter SoulReaper
  • Start date Start date
S

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.
 
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 *
 
SoulReaper said:
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.
Click to expand...


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