I am using the following 2 formulas to pull occurrances of a letter in a
column.
{=COUNT(IF(('Raw data'!L1:L65500<"A")*('Raw data'!B1:B65500="L"),'Raw
data'!Q1:Q65500))}
and
{=COUNT(IF(('Raw data'!L1:L65500<"A")*('Raw data'!B1:B65500="Z"),'Raw
data'!Q1:Q65500))}
The first formula works fine, but the second comes back with the wrong
total(should be 20 with my test data, giving 230). The only difference is
changing the "L" to a "Z". Is ="Z" used for something else in excel, i.e.
z-test or something? If so is there another way to get the occurrances of
"Z" in column B when column L ="A"?
--
Message posted via
http://www.officekb.com