Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a count of #of times a result occurred on multiple platforms
I'm using Excel 2003 SP2. I need a formula that will tell me how many times
tests passed across multiple platforms. For instance, I have two columns; A and B. Column A contains multiple platforms, ie: oracle, unix, mssql2K5. Column B contains the results pass, fail, blocked. ColA ColB mssql2k5 pass oracle pass unix fail mssql2k5 fail oracle pass unix fail mssql2k5 blocked oracle blocked unix blocked I can use COUNTIF and determine the number of pass/fail/blocked cases, and I can determine the number of platforms tested on. What I can't seem to get is the number of cases passed, etc. on mssql2K5, etc. What I want is something like =COUNTIF(A:A,"mssql2k5") and COUNTIF(B:B,"pass"). I tried using =COUNTIF(AND(AA:,"mssql2k5"),B:B,"pass") , and the other way around, but that didn't work. Is this type of formula possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion of Numercials to Figure | Excel Worksheet Functions | |||
Currency to Text | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) |