| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if and or statements
Hi, I have the following statement that works for what I need HOWEVER I now
need to also count the number of times "4.04" u2:u226 contains . I can't figure out how to add this extra search criteria. =SUM((COUNTIF(U2:U46,"3.028")+COUNTIF(U62:U226,"3. 028"))/COUNTA(U2:U46,U62: U226)) I have column T2:t460 that contains product 3000, 4000,5000, 6000, 8000. Then in column U2:u460 I have various versions. I need to figure the percentage of 3000 & 5000 that equal 3.028 or 4.04 thanks for any help you can offer. -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if statements, and statements | Excel Worksheet Functions | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| "IF Statements in Microsoft Excel | Excel Discussion (Misc queries) | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
Threaded Mode
