Home |
Search |
Today's Posts |
#1
|
|||
|
|||
="Z" dual use?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dual Justifications in a cell? | Excel Discussion (Misc queries) | |||
Opening two excel worksheets with dual monitors. | Excel Worksheet Functions | |||
I have dual monitors. I need to view spreadsheets on both monito. | New Users to Excel | |||
How do you create dual drop down menus in excel 2000? | Excel Discussion (Misc queries) | |||
Does a dual processor configuration noticeably improve Excel spre. | Excel Discussion (Misc queries) |