|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Count If Column A = x and Column B = y
Ahhh, ok, I have 2003
"Fred Smith" wrote:
This works only in Excel 2007. You should identify this when you are using
functions found only in the newest version.
Regards,
Fred.
"Chin via OfficeKB.com" <u50624@uwe wrote in message
news:94e93ddbaa04b@uwe...
Trish, please try:
=COUNTIFS(A1:A100,"A",B1:B100,"B")
Please advise if that is what you were looking for.
Trish wrote:
I am trying to use the count function where two conditions in different
columns need to be satisfied and having no luck. Basically I want to look
in
the first column to see if it's A, then look in 2nd column to see if it's
B,
then count it... is that possible?
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200904/1
|