|
|
|
|
#2
02-05-2018, 02:13 AM
|
|||
|
|||
Hi Xor
Brilliant works perfectly. My only other query is to check for values in column Q that are >=3 and/or <=4. I have tried both "AND" and "OR" but to no avail: =SUMPRODUCT(ISNUMBER(Risks!$Q$5:$Q$20)*(AND(Risks! $Q5:$Q20>=3,Risks!$Q5:$Q20<=4)*(Risks!$K5:$K20>=(--("1/4/18")))*(Risks!$K5:$K20<=--("30/4/18")))) Thanks for your help so far. Tony 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula needed; I'm helpless | Ylli | Excel | 10 | 12-13-2017 04:06 AM |
 Help needed with IF formula with a Vlookup
|
jonnie_rc | Excel | 6 | 08-31-2017 01:27 PM |
| Complicated Formula Needed | midgetmogalle | Excel | 14 | 01-29-2014 10:26 AM |
|
Formula help needed
|
Cosmo | Excel | 1 | 08-23-2012 11:50 AM |
| Excel formula needed. | Rod | Excel | 1 | 08-03-2009 06:55 AM |
Windows 10 
Office 2016
Hybrid Mode