| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mick & Clause & Experts Please help me on this issue one more time
I need help with the thread below."Countifs bites again"
https://groups.google.com/forum/?fro...ns/rDHn9VjHDlQ I am using the following now, but i realised an error in my logic. What needs to happen is that if the first 3 conditions are correct then I need to return the count of of all the columns AP8:AP107,AQ8:AQ107 & AR8:AR107 that have a value <=500. So if eg ap8 is 450 and ar8 is 350 then the function needs to return 2 and so on. =COUNTIFS(Sheet3!C8:C107,"*",Sheet3!AH8:AH107,"*", Sheet3!AO8:AO107,"*",Sheet3!AP8:AP107,"<=500",Shee t3!AQ8:AQ107,"<=500",Sheet3!AR8:AR107,"<=500") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time issue | Excel Programming | |||
| Can I use a between clause or in clause on an IF statement | Excel Programming | |||
| Excel format JOHN MICK to Text format "JOHN","MICK" | Excel Discussion (Misc queries) | |||
| "Between" in an IF clause | Excel Discussion (Misc queries) | |||
| Run Time Issue | Excel Programming | |||
Threaded Mode
